The Area being Modelled is :-
Packaging Equipment Manufacturers

Barry,
 >>
 >> Thank you for your response. I have been trying to figure out a way to structure a database so that it will work for the following business model:
 >>
 >> -Company sells packaging equipment such as box erectors, case packers (used to automatically pack products)
 >
 >> -Company has standard equipment that can include options (configurable)
 >
 >> -Company but does design, test, mfg and sell custom equipment
 >
 >> -Company is also a distributor for other OEM equipment in order to augment the product lines
 >>
 >> -Currently switching to salesforce as a CRM tool
 >
 >> -Goal is to be able to track internal Requests for Proposal from the sales team, capture the RFP data, use the data to trend what we are selling and
     to look back on what each proposed piece of equipment including its options etc.

     Also, would like the ability to create a proposal from the data which would include all of the technical data.

     Next phase of the project would be to use this to generate an invoice and a follow up order acknowledgement letter etc.
 >
 >
 > The aircraft parts sales model looks fairly close but... Also I am confused as how to use the reference tables with respect to input forms.
 >
 > Any help that you can provide would be outstanding. Thank you!
 >
 > Regards,
 >
 > Bill