relationship update

[richshone]

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.