Basic Quoting System

[Travstar]

Hi guys. VERY new to access, so please excuse my ignorance

OK: here is my (proposed) database:

I want to create a quoting system (as the subject suggests) and im not really sure about the relationships that need to be in place. Here is my current table structure:

Table: Product
Product Code <-- (pr k)
Description
Cost Price (ex tax)
Quantity
Sell Price (inc tax)

Table: Status
Status ID <--(pr k)
Status < -- this is the "status" of the quote ie: 'in progress', 'accepted', 'not accepted' etc..

Table: Quote
Quote ID <-- (pr k)
Created < --date created, auto generated ("=now()"??) will this work?
Expires < -- quote expiry date ("=now()+14"??) will this work?
Total (ex)
Total (inc)
TAX
Profit (ex)

Table: Salesman
SalesmanID <-- (pr k)
Salesman

Table: Company
Company ID <-- (pr k)
Company Name
Contact
phone number
fax number
street address
suburb
post code

OK, first some basic questions

1. Is this table structure ok? SHould I add/remove any data from it?

2. Where exactly should my relationships be? im totally lost with this part

3. ANY other suggestions with this would be appreciated

Thanks in advance!

Trav

 

[PHV]

At very first, have a look here:

http://r937.com/relational.html

Then study the Northwind sample database provided by msoffice.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ssatech]

Travstar,
Take a look at the Order Entry sample. This should give you the big picture. You should be able to use this as an example. Modify the table fields for your purpose and take a look at the table relationships to give you an idea. This design should work for your Quote System.



e.g.
Substitute the Customer Table for your Company Table
Substitute the Orders Table for your Quote Table
Substitute the Employees Table for your Salesman Table
You probable need a Quote Details Table, substitute the Orders Details Table with you Quote Details Table.
Produts Table self-explanatory.