Hi,

In one of the database I'm developping. I can't create a record via a relationships.

In this problem, there are 3 tables : Borrowers, borrow and files.

For each file there can be more than one borrower.

A borrower can have more than one file.

Borrow is the join table.

From my file layout I want to be able to create a borrow in a portal which link to the borrower.

I don't want the possibility from file layout to delete directly the borrower since he can also be an owner in the futur.

I attached the file, it might be easier to understand.

testDB.zip

It doesn't work that way. You don't have a key with a value in the join to relate to the borrowers.

You need to create them in the borrowers table and then make the join records.

I know that logically I should have created the record in the borrower table and then link it to the files.

But for convenience purpose, it was not possible this way. Since the secretary must enter the values using the simpliest way which means typing for her and scripting for me...