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!

 

[MarkK]

Check out the DCount() function , which counts records in a table based on criteria you supply. If it returns a number larger than zero...