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?

Cecil