>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.