How to Change or link tables from sub to parent form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I made a subform and for some reason linked the names from one table to the
next. Now I am having trouble with duplicate names.

How do I correct this and sync up to keep the correct data? Do I need to
make a new subform? Do I need to change the tables?
Here are my tables:

TNewCases
[ID]
[claimantfirst]
[ClaimantLast]
[Date of Birth]
+many more

TRatedAge
[raID]
[RADate]
[RALife company]
[RAage]
[RAby]
[claimantfirst]
[claimantlast]
[date of birth]
[ID]

Thanks for your help!

John
 
What sort of trouble?

Assuming that ID is the primary key of TNewCases, and the ID field in
TRatedAge is a foreign key related back to TNewCases, you shouldn't be
having any problems, assuming you've selected the correct record from
TNewCases.
 
Back
Top