How to Lookup from table, select record?

[deego55]

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!!

[Fitch]

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.