J
Joey
I have two forms corresponding to two tables in my database. I have an id
variable in table 1 that is set to autonumber and the same variable in table
2 set as a long integer. I have built a relationship between the two tables.
Form 1 sends all of its data to table 1 and form 2 to table 2. My issue is
that when I enter data into the forms the data goes to the correct table,
however the tables are not correctly linked as I cannot see the id in table
2, nor can I see the data from table two when I expand the id in table 1.
Any ideas???
variable in table 1 that is set to autonumber and the same variable in table
2 set as a long integer. I have built a relationship between the two tables.
Form 1 sends all of its data to table 1 and form 2 to table 2. My issue is
that when I enter data into the forms the data goes to the correct table,
however the tables are not correctly linked as I cannot see the id in table
2, nor can I see the data from table two when I expand the id in table 1.
Any ideas???