I have a table with Purchase Orders listed. Each order has a Salesperson and Assistant listed along with the order. Each Salesperson and Assistant can only see the orders in the table that have their name attached to it. I log their username when they log in with tempvars and call that back as a criteria in the query. Now there is a new twist. Certain orders will now have multiple assistants. I could add another column for the additional assistant and continue using tempvars to accomplish this, but that seems like sloppy design. Anyone have any ideas that would allow someone to view certain orders when their name is not attached directly to the order?