Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

passing value between 2 files

Status
Not open for further replies.

Kevin2569

Programmer
Joined
Dec 22, 2007
Messages
8
Location
AU
I have 2 database files: Clients and Contracts.

After I fill in the customer's detail on Clients file, I want to create a new record on Contracts file and auto fill in the CustomerID and full name.

I set variable at Clients:
Set variable[$$customerID; Value:Clients::customerID]
Set variable[$$fullname; Value:Clients::fullname]

On the Contracts:
Set Field[Contracts::customerID;$$customerID]
Set Field[Contracts::fullname;$$fullname]

But the Contracts customerID and fullname fields are blank, it cannot pass in the variables. How to pass value between files?

Thanks for your help.

Regards,
Kevin
 
Have you checked your "relationship" PK and FP?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top