AnsweredAssumed Answered

populating fields based on primary key without creating a new record.

Question asked by MarkBløndal on May 9, 2012
Latest reply on May 9, 2012 by MarkBløndal

Title

populating fields based on primary key without creating a new record.

Post

Hello

 

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 ? 

Outcomes