I have two forms(tables), both with imported data from different sources.
Both forms are full with data.
Form A
Name (Single line)
Descript 1 (Single line)
Descript 2 (Single line)
A_ID (Number)
Form B
Local (Single line)
Descript 6 (Single line)
Descript 72 (Single line)
B_ID (Number)
Now I want to create a relationship between the two forms. One-to-many (from Form A to Form B).
Do not really want to add more fields to these tables - if I add a new lookup field to these tables now, I will have the problem that this field is new, and do not contain any data.
How can this be done when all the fields allready are defined and filled with data?
Want to make a report (view) based on these two forms.
Lasse