I ended up using a Local VIew and will see how it works now. I've been implementing it this morning but have not yet tested it.
We shall see how it turns out.
Thanks Al,
Cecil
>>I am setting up a means to search for the following information:
>>
>>Last Name (in Customers table)
>>License Plate (Orders Table)
>>Vehicle ID Number (Orders Table)
>>Order Number (Orders Table)
>>
>?My concern is "How do I search by "Last Name" if it is actually in the CUSTOMERS table, which is related to the ORDERS table?
>>
>>I could over-program this, but I wonder if anyone else has run into this situation?
>>
>>I was thinking about making a View that would handle this. Is there another way?
>No doubt there are other ways to do it, but views were specifically designed to handle this sort of problem.