iFrame foreign key ?
Posted: Mon Oct 07, 2019 11:34 am
Hi guys!
I have 3 tables like these :
Family
family_id
[...]
Person
person_id
#person_family_id (foreign key)
[...]
Housing proposal
housing_proposal_id
#housing_proposal_family_id (foreign key)
[...]
One or several persons belong to one family and one family have one or several housing proposals.
In a form which contains all data related to the table 'person', I want to add a subform or an iFrame which give the list of all housing proposal of the family to the person belongs. But I don't know how to do.
Do u have any idea ?
Thanks for ur help!
I have 3 tables like these :
Family
family_id
[...]
Person
person_id
#person_family_id (foreign key)
[...]
Housing proposal
housing_proposal_id
#housing_proposal_family_id (foreign key)
[...]
One or several persons belong to one family and one family have one or several housing proposals.
In a form which contains all data related to the table 'person', I want to add a subform or an iFrame which give the list of all housing proposal of the family to the person belongs. But I don't know how to do.
Do u have any idea ?
Thanks for ur help!