depicting 1 - M relationship on a form!

[shez]

If i have 3 tables:
personal(id,...)
link(id,addressId,type)
address(addressId,...)

Now when I select all these fields and create a form I get one set of address details but i really want TWO! I can use "field list" in design mode and duplicate address related fields but how would access store them in the database and maintain relationship?

 

[mithani]

Have you tried query, put all three tables in a query and call query in your form.

Mithani

 

[shez]

Have you tried query, put all three tables in a query and call query in your form.

Mithani

would that query also help me to ADD info or just to view info? because if I want to add via form through that query, the query wont return any result?

 

[shez]

cheers for the answer, i did do that but i was wondering instead of having a subform could i not have two set of addresses text box? for example:

Type, houseNo, street...

Type, houseNo, street

and possibly Type in one set fixed to HOME and in the other it is fixed to TERM (there can only be TWO types!)

i also thought because there are only TWO types could i not do something like:

personal(id, name, homeAddressId, termAddressId...)
address(addressId,houseNo,street....)