PLease help me get this started

[Jason Walter]

With the help from the users of this group I have successfully completed
a project or two. I need some help again.

I think if someone gets me a plan I can complete this.

I have a list of audio/video components with descriptions and prices,
retail and cost.

I want to create a simple application that allows me to select different
components needed to create a complete A/V system. A list would be
generated showing the pricing.

Can someone guide me as to how this would be done?

Thanks
Jason

 

[tom]

You would need at least 3 tables, Components, Customers and Orders... and at
least a 1-Many relationship between Customers and Orders. Components would
hold all data relevant to A/V products, e.g. description, retail and cost
prices, as you mention below. Customers contains all data about your
clients, Orders then pulls information from the other 2 tables and prints to
a report on what the Customer has purchased... This would be a basic first
step and could be added to as the requirements are identified...

HTH.

Tom.

 

[Kevin Sprinkel]

I want to create a simple application that allows me to
select different

components needed to create a complete A/V system. A list would be
generated showing the pricing.

Can someone guide me as to how this would be done?

Jason

Jason,

This is essentially an order entry application. An
effective general strategy is to create three basic tables:

Components
The table you've described. Be sure to include a unique
key field, such as ComponentID.

Systems
Analogous to an Orders table, listing basic system
information such as SystemNumber (the key field), Date,
ClientID, etc.

SystemComponents
Analogous to an Order Detail table. Include SystemNumber
(a foreign key to tie the components to the system),
ComponentID, Qty, Discount.

A multitable form can then be created, based on the
Components table, or a query if you prefer. Place a
subform based on SystemComponents on the form. In
addition to the SystemComponents fields, the subform
should include controls to hold the price "looked up" from
the Products table, and a calculated Extd Price (Price*Qty*
(1-Discount)).

Controls on the main form can calculate subtotals, add
freight, etc., and show a grand total.

Your application is very similar to the sample Northwind
Orders app included w/Access. Go to Help to load the
application, and click on the Orders button to show the
order entry form. You can then explore the code
underlying the form and adapt it to your specific
application.

Hope that helps.

Best regards.

Kevin Sprinkel
Becker & Frondorf

 

[Jason Walter]

Thanks for the help. That should get me started.
Jason

 

[Guest]

-----Original Message-----
Thanks for the help. That should get me started.
Jason

As Tom mentions, you will also need a Customers table.
Again, refer to the Northwind sample.

HTH
Kevin Sprinkel
Becker & Frondorf