Hi, my set up is as follows:
Form1
>Subform1 (Name)
>Subform2 (Address)
>Subform3 (Bank Details)
Form2
>'Name' Lookup field to Subform1 (inputs name from Subform1 'Name' field)
>'Address' field (Want to input corresponding address that was entered into Subform2 at the same time as Subform1/3)
>'Bank Details' field (Want to input corresponding bank details that were entered into Subform3 at the same time as Subform1/2)
How do I link the subforms together?
Can I fetch from a combined report?
Unless i'm doing something wrong, the Record ID for Form1 does not contain Subform1/2/3 records.
Can I make an ID that identifies all the subform records as linked? (exact timestamp?)
If it helps, none of the subforms need or allow multiple rows.
Thanks!
Levi