April 2, 200223 yr Newbies 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.
Create an account or sign in to comment