2 Tables and a Combo Box

[Guest]

I have a transaction table with an input form. I have a form for that table
that has a bound combo box that reads peoples names and phone extensions and
populates the fields on the form with that info. However, when I look at the
transaction table, all I see is the ID number that the person has assigned to
them and see neither the name nor the extension in their appropriate fields.

I only have three columns in the combo box, ID, Name and Phone Extension. I
have column 1 assigned to the field in the transaction, but column 0 (the ID
number) is what holds in the file when I look at it.

Thanks in advance for the help.

 

[Douglas J Steele]

How does the Transaction table get populated?

 

[Guest]

The transaction table gets populated by user input or edit using the form
with which I am having the combo box problem. When they get to the name of
the engineer in charge of the transaction/project, they can only use the
names we have in another table (ID, Name, Phone Ext.). The form shows the
correct name and extension, but it doesn't get saved in the transaction table
and when I do a report I only get the ID number.

 

[Douglas J Steele]

If the ID is sufficient to get the name and phone extension, then the name
and phone extension shouldn't be stored in the transaction table anyhow: you
can get them by joining the transaction table to the table that contains
that information.

 

[Guest]

I agree with you on that. Thank you very much for your help.