2 related tables

[mmm286]

Hi,
I have 2 related tables by ID field.
In a subform I have all fields of a one table, when I make click in a button, open other form with info related by these ID.
All is ok but I have some doubts:
If in the second form (second table) there is no registers, how could shows me the ID by default and that the ID field is not empty
If I create a new register inside second form with a button, I would like that the ID field was always filled because the user don't need to know the ID
Many thanks and sorry for my English!

 

[jdraw]

I do not understand your issue. Where do Registers fit?
Normally with form/subform you have 2 related tables. The tables are related 1 to Many.
The 1 side is the Form (eg Person) the many side is the recordsource for the subform (eg Hobby).

The concept is 1 Person may have Many Hobbies.

 

[mmm286]

I do not understand your issue. Where do Registers fit?
Normally with form/subform you have 2 related tables. The tables are related 1 to Many.
The 1 side is the Form (eg Person) the many side is the recordsource for the subform (eg Hobby).

The concept is 1 Person may have Many Hobbies.

Ok I understand you.
but I would like to open the subform in other window, I dont like that the subform is in the same window than the main form
How could I do these?
Thanks and sorry for my english!