List Box in Form

[Guest]

I have a Production Schedule form based on a Prod Sched Table that includes
the production info. I also have a table and form that has Cust Name and
Address info. I want to make entries into my Prod Sched form and be able to
choose a name and address from the Cust Name table. When using a List/Combo
box I can only get a name. I must have both the name and address info. Is
it possible to do this??

 

[Dan Artuso]

Hi,
You shouldn't be storing all that info in another table.
You only need to store the CustId. You can have your combo/listbox display
the name and address but your bound column should be the CustId (or whatever you called it)
and that is what should be stored in your Prod Sched Table.
You get the info displayed by having a query similar to this for your combos rowsource:

Select CustId, LastName & "," & FirstName & " " & Address AS NameAddress From yourTable
So then you would see the info but only store the ID as a foreign key.