Validate Data Between Tables

[Len in Winnipeg]

I am building an estimating solution and I am having problems validating that an active customer number has been entered.

I have a Customer Table with all relevent customer information, then in a separate table I have the estimating information. I have it set up through scripts and a custom dialog box with globals to request a customer number and navigate to the estimating table create the new record and lookup all the required customer information.

What I would like to do once a user has entered a customer number (into the global field via the custom message) is to compare it to the data in the customer table to make sure that the customer number is valid before it creates a new record in the estimating table.

Althought this does seem simple I am totally brain dead on how to accomplish this.

Any input is greatly appreciated

Thanks

Len

[-Queue-]

Create a relationship between the global and your Customer::customer_number field. After the global is entered,

Commit Records/Requests

If [not IsEmpty(relationship::serial)]

{create new estimate record}

Else

Show Custom Dialog ["There is no current customer with the entered number."]

End If