Hi,

I want to display two related table fields in a combo box,
For example there are two tables
DISTRICT and STREET
set the relation DISTRICT.districtid into STREET

I want the combo box display for selection as follow:-

DISTRICT.districtname, districtid, STREET.streetname

What RowSource and RowSourceType should I set ?

Please advise.

Thanks.
Derek Yim