February 3, 200521 yr Hi, I am trying to add a set of new tables to an existing database and am looking for a couple of suggestions how to make the relationships work. I have the following tables: event groups (related by a DATE RANGE calculation to...) events finally, I have clients What I want to add is a sales table that lists inventory, defined by clients AND by event group so when looking at an event, only the inventory related to both will be available for calculation. I will need to total sales and calculate sales tax/commissions with this data so I am concerned that a portal will not be a sufficient way to view this data. I will also need to add inventory for numerous clients on an ongoing basis. Any ideas would be appreciated.
Create an account or sign in to comment