Jump to content

How to Lookup from table, select record?


deego55

This topic is 6491 days old. Please don't post here. Open a new topic instead.

Recommended Posts

fairly newbie question:

I have a contracts table. I want to add a vendor field and a button that will open the vendor table, allow me to select a vendor and populate the information in the contracts table.

I know i will need a new vendor layout with a button to select the record, but i cant figure out how to script this. thanks for any help!!

Link to comment
Share on other sites

There are two parts to this.

Part I: a script/button on your contracts layout that goes to a layout based on vendor; this layout shows a list of vendors and has a button to run your "vendor select" script.

Part II: the button on this vendor layout runs the "vendor select" script with a script parameter of vendor id. The script would be simply:

Go to layout[ contracts ]

Set field[ vendor id ; Get ( ScriptParameter ) ]

Commit record

and etc.

You may have contract fields set to lookup based on vendor id, or you can simply display the related vendor fields on the contract layout.

Link to comment
Share on other sites

This topic is 6491 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.