Linked Tables

[Dickx]

How do I link tables within the same database so that entry into multiple fields in table A will automatically populate the same fields in table B.

 

[PHV]

Are you sure you want to store duplicates values breaking the normalization rules ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Dickx]

Yes. My purpose is to create derived (calculated) fields in table B based on enteries made in table A and linked to table B

 

[PHV]

Take a look here:

http://www.abcdataworks.com/fundamentals.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244