populating fields based on primary key without creating a new record.
I am trying to populate 4 fields based on the input from one field
(From one table:Personnel, into a form in another table:Borrowed . All 5 fields are from the personnel table.)
My setup is quite straight forward
Field 1: CPR Number (Primary Key) Personnel::CPR
Field 2-5: related information based on Field 1(Personnel::name, Personnel::email, phone, and group).Personnel::phone, and Personnel::group).
I tried simply inserting a field from table:Personnel, but when I typed in CPR it would search and populate Field2-5 correctly BUT in my Personnel table it would then create a new record with the CPR value - And no other values.
Instead of (as expected) simply using the value from an already existing record with that CPR number.
I apparently can not search Personnel unles I make the relation between them able to create in both tables.
The whole point is to make Borrowed a form for items to lend to personnel, without ever changing the Personnel table.
Borrowed is a mix of Equipment and Personnel neither of which is supposed to be changeable.
What would be the ideal way to perform this simple task ?