Table Relationships and Adding Data

[Karl Burrows]

I want to create a table to populate a combo box in another main table. The
problem is if I input another value in the main table, I want it to also
populate the table used for the values in the combo box. I'm stuck. Any
help would be appreciated!

 

[Allen Browne]

See:
NotInList: Adding values to lookup tables
at:
http://members.iinet.net.au/~allenbrowne/ser-27.html

 

[John Vinson]

I want to create a table to populate a combo box in another main table. The
problem is if I input another value in the main table, I want it to also
populate the table used for the values in the combo box. I'm stuck. Any
help would be appreciated!

Umm... just use the table as the Row Source for the combo box. If the
form with the combo is open while you're editing the table you may
need to requery it.

If you're using the Lookup Wizard to put a combo box in a table,
consider using a Form instead. The lookup feature causes more problems
than it solves - see http://www.mvps.org/access/lookupfields.htm for a
critique.