Creating Estimates

[mpascaru]

Looking for a start with relationship structure.

Table A. 15 Categories, ID & Name. A category can have 10 to 15 details, it will always be the same number and type of detail.

Table B. 25 Details, ID & Name.

Each Detail has sub-details with prices.

Ideally, when a user selects an estimate category from a value list and clicks on an (enter details) button, he will be on a layout where all the category details are listed and the estimate quantities can be entered.

I've considered portals for the quantity entry to a join table, but fear that at times some of the line items for a complete estimate would be missed without a reminder list.

Also, I was going to have a separate Sell Price Table with ID, Name & Amount so that Price adjustments could be easily handled by the user.

I'm completely open to any suggestions and do need a kick in the right direction.

Thanks,

M