table designing ms access

[Faisal]

There is any way to have a field name should automaticaly liknked with
another table
becuse i want to design a table in there field name should updated
utomaticaly from another table
any tips
regrds
faisal
Riyadh

 

[Michel Walsh]

DO NOT duplicate the field. Make it appearing in a single table and if you
need it, associated to data from a second table, use a JOIN to retrieve it.


Sure, I assume your just refer to the field. There are cases where you may
need, indeed, to update a field (such as getting a new inventory, so the
quantities may have to be updated, or for archiving purposes), but in
general, the idea is to write the data JUST ONCE, so it minimizes the
possibilities of error (of any kind) and use JOIN to associate it with other
records from other tables.



Vanderghast, Access MVP