Foreign Key Update?

[jjfcpa]

I have 3 tables: Clients, Loans, Payments

I have related these as follows:

Clients to Loans and Loans to Payments

Client Loans Payments

--------- -------- -------

kp_client -> kf_client

kp_loans - > kf_loans

kp_payments

I have just one occurrence called Clients and the clients are entered on one layout and the loans are entered on another layout.

The problem is, when I enter a loan (there is a button on the client's layout that will take you to the Add Loan layout), the kf_client foreign key is not getting added to the table. I tried adding a calculation in the auto-enter options to add the kp_client from the client table but it's still ends up empty. What am I doing wrong.

Need I say that I am new to this?

[bcooney]

New Loan button on Client Form runs the script, New Loan from Client:

$clientID = Client::_kP_ClientID

Go to Layout (Loans)

New Rec

Set Field ( Loans:_kF_ClientID; $clientID)

[jjfcpa]

Simple, once you know how to do it. Thank you from the bottom of my heart.