linking data

[Scott]

I have an access database that I want to use the data from one table into
another. One table has ‘category’ and ‘categoryID’. Table two has the same
two fields. I want to be able to select in table two the ‘category’ from a
drop down list and have the ‘categoryID’ updated to reflect the change made
in the ‘category’ selection. Is this possible? If so, how do I do it?

Thank you for your assistance,
Scott St. Gelais

 

[NetworkTrade]

you should think in terms of working in forms; and not working directly in
tables. tables have no events to trigger VBA to write something to another
field.

the classic database reply to your request is that there is no need to
change CategoryID & store it in a second table. the 2 category fields are
the cross referencing fields....any time you need to display the ID you can
via query that joins these tables.

probably the most traditional design is with a form sourced on Table 2; you
would add a combobox sourced on Table1