Report selection by customer

[Pat Hartman]

Except that the customer name doesn't belong in the order table. The customer name belongs in the customer table and ONLY the customer table. When you need to show the customer name, you use a combo on a form. The combo is bound to the CustomerID but shows the customer name. For a report, you would not use a combo, although you could. You would join to the Customer table in the report's RecordSource query. That lets you pick up the customer name as well as any other data that is stored in the customer table.

You're welcome, I think. You might want to work on normalizing your tables though.