Purchase Order application

[Sammy]

I need some direction to create a purchase order
datatase - I can't get it to work. I want to select
items ordered from another table, and assign them to the
purchase order. The items table will contain part
number, description, and price. Once the item is on the
PO, I will add the quantity, be able to change the price
(without changing the price on the item in the original
table) and have access do the math to calculate the total
line item and total order. Do I use a subform, a list
box, a combo box, or what? How do I tie the items table
to the orders table? I hope to apply this principle to
other aspects of the order, such as looking up the vendor
name and assigning it to the PO. I hope someone can
help - I've gone in circles trying to make this work.
Thanks.

 

[Allen Browne]

Sammy, open the Northwind sample database that came with Access.
Choose Relationships from the Tools menu.
Look at the structure:
- One order has many order details.
- One order detail refers to the products table.
- The order detail table has the order price, which may be different from
the product price.

Although Northwind is designed for sales orders, the structure you need will
be very simple, except you will have a table of Vendors instead of
Customers.

You can also see how the Orders form works in Northwind, for an idea of how
to build your interface.

 

[Sammy]

This was very helpful. Thank you. I copied the
pertinent forms, queries & reports to create my database,
but have come accross a roadblock. In the order form,
combo box for customerID from the customers table, I
changed it to "vendorID" from the vendors table, and
changed the vendorID field from 5 txt characters to 20
text characters in the vendors table. Small vendor names
work fine, but when I try to enter a 15-character vendor
into the combo box, I get an error message that
says, "The field is too small to accept the amount of
data you attempted to add. Try inserting or pasting less
data." Why am I getting this messsage? I am very
grateful for your help. Sammy

 

[Allen Browne]

The changes you made were:
Customers table renamed to Vendors
CustomerID field renamed to VendorID
VendorID field resized to 20 characters

The Orders table also has a CustomerID field.
Did you resize this to 20 characters as well?

 

[Sammy]

-----Original Message-----
The changes you made were:
Customers table renamed to Vendors
CustomerID field renamed to VendorID
VendorID field resized to 20 characters

The Orders table also has a CustomerID field.
Did you resize this to 20 characters as well?


--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
Bingo! Thank you, Allen. I'm on my way.