View Single Post
  #2  
Old June 22nd, 2004, 01:21 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default Understanding a combo box filling another table's field

Are you saying you used a "lookup" data type in your table? This may cause
you headaches later on, especially if your ZIPCode table uses a primary key,
and your Contact table is storing the key, but displaying the ZIPCode.

Rather than working directly in the table, consider using a form to display
information. Build a combo box on the form that uses the ZIPCode table as a
row source, and is bound to the Contact table ZIPCode field. You would need
to change the "lookup" datatype to an appropriate different type.

--
Good luck

Jeff Boyce
Access MVP