sales extended

[Jon]

Hi,
I have a hard copy form which needs to be transfer into Database is as
follows:
Customer ID
Address
Sale ID
Item
Name
Quantity
List Price
Sale Price
Quantity Shipped
Back Order
Extended
I have to design the above senior but I am stuck with the Back Order and
Extended.
Should I make table for Back order and another table for Extended? My
problem is with business transaction, I do not have enough back ground in
Sales field. Anyone can help me.

 

[Gina Whipp]

Jon,

First ot answer your question. Backorder and Extended should not be stored
in a table as it is a calculation, [Quantity]-[Quantity Shipped] and
[Quantity]*[Sale Price].

You say you want to copy a form, I am assuming you mean a piece of paper?
You are jumping the gun. What you need to do first is figure out your Data
Model (what you want to accomplish) and then move on to forms and reports
(your piece of paper). You can look at the Nortwind sample database that
came with your version of Access to help you better understand. Below are
some questions that will help better understand how to advise you for table
set-up.

1. Are you going to store Customers?
2. Are you going to have an Item table?
2a. Will the Item table store prices?
3. Is SaleID something that attached to Customer or Item or both?
4. Are Sales attached to sales people?
4a. Will you need to have reports for that?
5. Are these Orders or Purchase Orders that turn into Orders?

Here are some links to help you understand Access...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

http://www.databasedev.co.uk/table-of-contents.html

Here's a link to help you undertand Reserved Words, that you should not be
used as field names...

http://allenbrowne.com/AppIssueBadWord.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm