Help

[Shoo]

Hi - I am struggling to put together a basic working Access stock, order processing and invoice system for a mock company in an elective that I unfortunately undertook. The System is based on the attached tables (the only part of the system that I think I have gotten right).

Everything I have tried fails, none of my queries or forms work properly.

In essence this is what I require:

An order form consisting of:

Customer ID - when desired ID is selected the rest of the details such as name and addy appear on selection.

Order ID - Order Date - Ship Date - Employee ID (for commission and reference purposes)

Sub Form

Product ID (when desired ID selected description and unit price auto appear) - Quantity - TotalUnitPrice

I think I have the brainpower to work out subtotals, taxes commission etc.

If you have the time and can be bothered - how would u create the order form based on the five given tables...

Any help would be highly appreciated. I am pretty much an access newbie with only the ability to follow instructions, not as yet able to innovate.

Thanks.

 

[Pat Hartman]

Take a look at the northwind.mdb sample database that comes with Access. It is a basic order entry system and you should find your questions ansered by reviewing its forms.

BTW, Name is a poor choice for a column name since it is the name of a property and will cause problems if you need to use it in VBA. Also avoid Function() names such as Date and don't use special characters or embedded spaces.