drop downs in billing form

[spencer]

I'm trying to create a billing form that contains drop
down lists for both my customers and my vendors. I did
something similar once before but it was a cobbled
together mess and I'd like to do things cleanly and
correctly this time. Here's the lay of the land:

TblCustomer
[CustomerID](key field)
[FirstName]
[LastName]

TblVendor
[VendorID](key field)
[FirstName]
[LastName]

TblBilling
[BillID](key field)
[CustomerID]
[VendorID]

TblBilldetail
[BilldetailID](key field)
[BillID]
[Amount]

The bill detail will be a subform of the billing form and
I know how to set that up. What I don't know how to do is
to create drop downs for Customer and Vendor Names in the
main part of the billing form. Ideally the drop down lists
would show up as "LastName, FirstName" though that's not
essential. I know how to create this concatenation in a
query but I don't know how to pull it all together on the
form so that everything is properly linked and functional.

Any help with design would be much appreciated.

spencer

 

[tina]

if you know how to pull the data you want (from each table, respectively)
and concatenate where desired, the build the queries and use each one as the
RowSource of the combo boxes (drop downs) respectively.

hth