Lookups - how to return two fields from a parent arther than just the ID number?

Hi All,

Completely new to SC, and have been doing some simple grid / form applications and have run into a brick wall, and need your help.

I have a form and I need to select a parent record that is linked by say CustID. I want to return not just the CustID, so that the records can be linked in the database, but also display their First and Last name fields.

At this moment, I have set up a link to capture the CustID field and it returns the INT value of the CustID, but how do I get the other information and display it?

Many Thanks

Tony

Suggest you watch the videos, they answer most all questions. http://www.scriptcase.net/scriptcase-videos/

Dave