Relationship probem...

[El_Pablo]

Hi,

I'm having a problem trying to enter a value in a layout from a related table.

Let say Two tables.

evaluationFile (pkEvaluationID, fkSoldPropertyID)

soldProperties (pkSoldPropertyID, ckSellNumber, address, blablabla...)

Both table are linked via the pkSoldPropertyID -= fkSoldPropertyID.

Bigger image

The user cannot view the primary key (pk) field. He can only use the candidate key (ck).

How can a new evaluation be automatically linked if the user enter the ck in a layout?

Any advice would be helpful!