ContactId

[Guest]

on the sample database the contactid field is set to "autonumber" in the main
table and "number" in the calls talble. However when you review the user
entered information in the calls table the contactid is not showing as the
assigned "autonumber" but as the first and last name.

I would like to use this technique as it would work better for my own db.

any info. would be appreciated.

thanks
martin

 

[Allen Browne]

Open the Calls table in design view, and select the number field.

In the lower pane, there is a Lookup tab.
On this tab, you will see that the Display Control is set to Combo, and the
other properties describe what columns the combo has and where its data
comes from.

In the upper pane of table design, there is a data type called Lookup
Wizard". That actually walks you through the steps of creating the combo for
the field, but it has some nasty side effects. Before you race into that
technique, read:
The Evils of Lookup Fields in Tables
at:
http://www.mvps.org/access/lookupfields.htm