linking data

  • Thread starter Thread starter Scott
  • Start date Start date
S

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
 
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
 
Back
Top