Purchase Order database with multiple quantities

[KChampion]

I am creating a database for purchase orders. I have almost everything created except for the order items. In the table I created how would I be able to add multiple parts that the customer orders to one purchase order? I have attached a word doc to show how it looks and highlighted what I am talking about. I have also attached the database I am working on named AceVision1. Thanks for any help.

[June7]

Not much of a db - only 1 table. No tables for products or vendors or customers (are you selling or just buying?).

If you want to allow multiple items for each order, then need a 'child' table. This is a 1-to-many relationship. Review http://office.microsoft.com/en-us/ac...010098674.aspx

[orange]

I agree with June7 -- a one table database is extremely rare.
I suggest you write a 5-6 line description of how this PurchaseOrder fits within the business.
Are there Customers, Products, Suppliers? -- How do you change the Price of a Product?

Also, you really should adopt a naming convention that doesn't allow spaces or special characters within field and object names. Use only alphanumeric and "_" underscore in your names. It will save you many syntax issues.

If you are quite good at learning by Watching/Listening
rather than reading, then this list might be useful to you.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

https://www.youtube.com/watch?v=lXAG...6FE5448948D9B4 E-R Diagramming Price and Quantity

Complete set of tutorials on Acc2010.
https://www.youtube.com/playlist?lis...FoilxbUY0yUqZP

[Jaci]

Did you ever get this worked out? I have a similar problem with a PO database that only has one table

[June7]

Jaci,

Follow the advice given to KC.