I have two tables linked by a one-to-one relationship.
In my form, I want the user to add the record in both tables at the same time (in one action like a clic on button).
Table 1 :
- id1 1 ,2 , 3, 4 primary key
- a bla, bla, hey!
- b data1, data2, data3, data4
- c 3 , 2, 26, 27
Table 2 :
- id2 2 , 3 primary key (that has to be in id1)
- d true, false
- e more, more
I don’t want the user to enter first table 1 and then table 2 in a subform because he can quit before filling table 2, and in this form, I really want the user to fill table 2.
In my form, I would like my user to fill :
a, b, c, d, e [push button]
The id would be autofield both for id1 and id2.
I made a query with data entry possibility for both tables but I can’t correlate id1 and id2 in the same table can I?
I thought about filters but here the main problem is the autofield on the primary key of table1, that I can’t reach to pass to table2 in one clic.
Is there a way to do this or several ways? I thought about a subform but I can’t manage it. Some examples around here?