autofill from other table bassed on come from

[titanium]

Hi,

I haven't been able to track this one down so appreciate any thoughts that you may have.

I have a basic customer table and a systems table. In the customer form i want to click "add system" which brings open its own window to create a system in the system table. I want to have the customer ID in the system table auto fill bassed on the ID of the customer im looking at when i click add system.

I have attached a copy of the file for a more clear picture. Once in the customer layout, click on the systems tab and a button will show and allow you to add a system.

Any pointers would be greatly appreciated.

AFPS2.zip

[aldipalo]

Welcome to the Forum.

There are 2 ways to accomplish what you want.

You can just add the new system to the System portal. You accomplish this by checking "Allow New Record Creation" on the system side of the relationship in the TOG (Relationship graph).

You can also set a variable in your script that grabs the CustID and holds it when you change to the system layout and then by using the Set Field() command you can place the CustId in the system::CustID.

See attached for both approaches.

hth

AFPS2_Mod.zip

[titanium]

Thanks very much for your help. I like and will apply the script solution. Very simple now that i see it, but of course would have never figured it out on my own.

The example you provided will be very useful for alot of the other things that i plan on doing with this DB.

Much thanks.