Design Suggestions Please

[terryvanduzee]

Hello

I am just starting a business from home for Computer repair/software/hardware upgrades etc.

I am designing a database to record the work I do and to provide the customer with a receipt for the work.

The work would be itemized in a form (much like an invoice you would receive).

I have a "tblCustomers" Table and a "tblCompleted" table.

When I open a form, it should display all work I have previously done for the customer (based on customer# - Autonumber value). If it is a new job I am doing for that customer, then I should just add a new record and for each line in the form I would place specific work:

Example:
Bob Jones is a current customer.
He brings his computer in and I do the following:
1. Remove spyware qty = 1, price=$40
2. Remove virii qty = 1, price=$40
3. Upgrade the Ram-1GB qty = 2, price per = $35

On my form there will be the customer information on the top
A subform containing the work performed (tblCompleted table).
A column for "Item", "Qty" and "Price Per".
How can I place several "items", "qty" and "price per" in a single subform?

I plan on calculating etc on the form as the extended cost and taxes etc.

Any suggestions?

Thank you
Terry

 

[Rabbie]

Have a look at the Northwind sample DB that comes with Access. The Order screen is doing very similar to what you want to do.

You need to have a Customer table, A Job table and a Job Item table.

This will enable you to build an entry form to record the work you do for each customer in each job.

Please post any queries.

 

[Rabbie]

I would have the customer selection Box in the form header, The Job information such as date in the Mainform and then enter the details like item, qty and "priceper" in the subform.