R
R S via AccessMonster.com
I do not understand how Access relationships get updated. If I have a one to
many relationship and the same field in Table1.Sports as in Table2.Sports
then how do the records in table2 get updated. Do I need to input the
information in both tables manually (twice)?
For example, if I have the following two records (sports) in two different
tables:
Table1.Sports
Football
Soccer
Hockey
Table2.Sports
Football
Soccer
Hockey
Hockey
Hockey
How does Table2.Sports field get populated when I manually update Table1.
Sports by inputting new records?
I have never been able to understand how the foreign key gets updated.
Thanks.
Richard
many relationship and the same field in Table1.Sports as in Table2.Sports
then how do the records in table2 get updated. Do I need to input the
information in both tables manually (twice)?
For example, if I have the following two records (sports) in two different
tables:
Table1.Sports
Football
Soccer
Hockey
Table2.Sports
Football
Soccer
Hockey
Hockey
Hockey
How does Table2.Sports field get populated when I manually update Table1.
Sports by inputting new records?
I have never been able to understand how the foreign key gets updated.
Thanks.
Richard