Filtering Forms

[David Jay]

Hello Group,

I use MS Access to print delivery slips for my customers. Customers are
assigned a "Route Number" and "Sequence Number". When I need to generate a
route to print, i simply filter the route field to the particular route I
would like to print, sort by Sequence, and go ahead and print.

Some customers however, I would like in 2 seperate routes, with 2 seperate
sequence numbers (sequence number not as important). I would like to
generate only 1 record per customer, so how would I go about allowing the
same customer record to be printed in 2 seperate route batches? Any ideas?

Thanks group,

Dave.

 

[Paul]

Store customer details in one table with a CustomerID field.

Store route details in a separate table (that includes a CustomerID field).

Set the relationship on the new table.

When printing, filter by customerID rather than the route so that all routes
for customer X are returned.