Hi, I have two tables each with a form.
They are set up as a one to many relationshiop
T1 PK is BTID auto number
T2 PK is ACQID auto number and it has BTID number
I joined T1 to T1 on BTID one to many, enforce etc..
Now, I have two forms created from these tables.
I have a button on T1 form that opens T2 form to add one or many records.
The issue I cannot seem to figure out is when I open T2 from T1 the BTID is always blank and I want it to populate with the BTID from T1 so the relate is done.
Can anyone help me?
Thanks.
Fen
They are set up as a one to many relationshiop
T1 PK is BTID auto number
T2 PK is ACQID auto number and it has BTID number
I joined T1 to T1 on BTID one to many, enforce etc..
Now, I have two forms created from these tables.
I have a button on T1 form that opens T2 form to add one or many records.
The issue I cannot seem to figure out is when I open T2 from T1 the BTID is always blank and I want it to populate with the BTID from T1 so the relate is done.
Can anyone help me?
Thanks.
Fen