Check to see if record id exists in joined table

[csoseman]

Is there a function that will return a boolean value to check to see if one record exists in a joined table? For example:

In one table you have a list of customers and their respective customer IDs:
customerID - PK
customerName
customerAddress
etc....

In another table you have:
orderID - PK
customerID - lookup field
orderAmount
etc....

Is there a built in function to do a boolean test to see if customer ID has any orders on record in the orders table? Any help would be appreciated!

[rpeare]

Depending on what you're going to do with the results you can do it one of two ways.

one is to create a query that only returns the results you want to see, then count the records in that data set before you do anything else.

The other option is to use the dcount function. domain functions (dsum, dcount, davg, dlookup, etc) are very inefficient though and should not be used (in my opinion) for frequently repeated tasks.