Database Setup

[mmika76]

Hey Everyone,

I am currently working on a project that was previously done in several excel spreadsheets. I thought I'd put everything in a database and make it easier. The problem is that it's not working.

Objective:

Track monthly and YTD costs of sample products ordered by 36 sales representatives.

I created a table for the 36 sales reps which included 2 fields - sales person number and name. I'd like to track orders placed by sales person number. (tblReps)

I imported product information including product code, web quantity, unit of measure, and pricing information into a second table. (tblProducts)

Then I created another table (tblOrders) with fields for sales person number, date, quantity, product code, web quantity, U/M, price, and total. (Is it possible to do a calculated field such as total in a table?)

I'm stuck here. Ultimately I want to create a form which will display the sales person's number and name, quantity ordered, drop down lists for product codes, which when a product is selected will populate the remaining fields such as size, description, and pricing information from the product table.

Then I'd like to create reports via queries that would display sales by rep, and a summary report of monthly and ytd sales, which is not a problem.

Any suggestions / guidance are EXTREMELY appreciated!

Thanks in advance.

File attached.

 

[scottfarcus]

2 points and then we can move on to email if you like...

1) Break up name into LastName, FirstName. You'll thank me later.

2) Don't STORE calculated numbers in tables. You can always calculate the numbers on forms or reports, but it is considered bad practice to store them.

Feel free to email me.

farcuss@hotmail.com

 

[scottfarcus]

forgot to activate my account.

feel free to email me.

farcuss@hotmail.com