richshone Posted February 3, 2005 Share Posted February 3, 2005 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. Link to comment Share on other sites More sharing options...
This topic is 6621 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now