hi,
looking for some advice on the deisgn of my tables i currently have setup.
the app is a sales management system. the sellers sell insurance policies, be it life, buildings etc
what i was wondering was to allow calculations of commission due from each product table (as they all have different criteria) should i just query them or setup a table that gets the values from the commission columns in each table?
also the same for the due date calculations, should i setup a table which gets all the due date calculations from their product tables and put into one table or just query each time with joins?
another thing is i had setup policy number as the PK however as the new policy can go under the same policy number should i setup a new column which is "product1id" as the PK AI ?
any advice would greatly be appreciated as i am just playing around with the tables just now before it goes any further.
many thanks