I am writing my first app which interfaces with a third party SQL database.

I need to validate certain fields to make sure that the data entered in the VFP App exists in the related SQL tables. For example; a Customer ID entered for an invoice exists in the SQL Customer Master file.

The way I have been verifying the fields has been to to create a Parameterized View for that field and then Requerying it, and making sure that the data contained in the View equals what was entered in the field.

I would prefer to do this at the Database level, so that I don't have to maintain the App, just the database.

How would I do this ?

TIA

Mark