I have recently designed a tracking database that is for a transportation logistics system, I have 1carrier vs. many shipment numbers.



John Doe carrier / Jane Doe Client
Shipping#/status/date of action/ck#/ammnt
shipping#/status/date of action/ck#/ammnt
shipping#/status/date of action/ck#/ammnt
shipping#/status/date of action/ck#/ammnt
Etc ....can be up to fifty account#

I need to be able to reply to the carrier with only their list of acct nmbrs possibly (rarely)from more than one client that are generated randomly,No 2 acct numbers will be the same except on rare occations. I have 12,000 carriers and 150 Clients
Is this even possible?????