![Quote](images/misc/quote_icon.png)
Originally Posted by
ArviLaanemets
You link secondary subform to unbound control in main bound/unbound form.
An example:
The Main form is bound single one (for this example), with fForm0 as source. fForm0 is based on table Table0, with PK Table0ID.. The 1st continuous subfrom is sfForm1, with fForm1 as source. fForm1 is based on table Table1, with PK Table1ID, and FK fkTable0ID. The 2nd continuous subform is sfForm2 , with fForm2 as source. fForm2 is based on Table2, with PK Table2ID, and with FK fkTable1ID. In fForm0, you have a hidden textbox txtTable1ID, which is updated with Table1ID of active row in Form1, whenever you update a record in Form1, or select there another record.
You set up the 1st subform as usual:
LinkMasterFields = 'Table0ID'
LinkChildFields = 'fkTable0ID'
You set up the 2nd subform as:
LinkMasterFields = 'txtTable1ID' -- The link is defined through hidden control in main form, not through primary key of Table1! What is logical, as fForm0 doesn't know anything about Table1, and technically sfForm2 is subform of fForm0!
LinkChildFields = 'fkTable1ID'
NB! For 2nd subform, you can't use wizard, i.e. you have to define the connection manually!