update between table

[phpatrick]

Hi, perhaps a basic question,

Situation : I have a form where I put in or change data of a person eg. name - birth - statue..
Each person is living somewhere, at least on one location, this is the data form the hometable. To link these two I use a between table, in the past I encounter persons who belong to more then one company.

Problem : Of course when I base the form on one query (person + betweentable + home) I can show the existing data but I can't update or add new persons.
A solution is to work with a subform (home), but are there other ?

 

[Remou]

If your tables are uniquely index, it should be possible to add records to the query Person + BetweenTable + Home.

For example:
[tt]tblPerson
PersonID - PK

tblHome
HomeID - PK

tblBetween
PersonID ) PK
HomeID )[/tt]