hi ray thanks for all your help today.
i was wondering if you could give me some general advice on my database setup in orde to achieve my results using WA extensions.
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 with joins 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 ?
many thanks