Automatically filling a field with a variable

[ianwarren]

Hi, I have a database with a list of clients and for each client you can add a list of enquiries they make.

What I want to do is for the enquiry form to appear on a new page when you click a button, so what I'm trying to do is create a variable that copies the clientID record from the CLIENTS table and then automatically pastes it into the ClientID record for the new enquiry in the CLIENT ENQUIRIES table. I'm trying to use scriptmaker to get this to work, and so far I have:

- Set Variable [$IDforEnquiry; Value:clients::Client ID]

- Go to Layout ["Client Enquiries"(Client Enquiries)]

- New Record/Request

but I'm missing that vital last line that will paste my new variable into the Client ID field of the CLIENT ENQUIRIES table.

I'm sure there is a simple solution to this but it's driving me mad trying to work out what it is! Any help would be greatly appreciated!

[LaRetta]

Hi Ian,

It would be:

Set Field [ Client Enquiries::Client ID ; $ID forEnquiry ]

Commit Records/Requests

BTW, I could not decypher your other scripts (from your other post), sorry. I was going to take another look today but without the files, I don't hold out much hope. Maybe others can figure it out.

LaRetta