Newbie help please

[David Langford]

I distribute product for the travel industry. I am try to build a database to help me mange the distribution process as it grows.

I have db01 containing the names of my clients, db02 containing the client's products and db03 containing the names of the agents I distribute to.

The agent db has about 3,000 records. I have constructed a portal using simple relationships (A:A) to display the clients products.

Each client catagorises the agents (a, b, c, etc.) by product. So agent one may get 20 of product A from client 1 but 6 of product b from client 2. The problem is that each I need to catagorise the product displayed in the portal specific to the agent and still be able to perform finds etc.

Any help much appreicated.

David.