Order form

[Mike Revis]

Hi Group,
Access 2007, WinXP

I have looked at the inventory template and the Northwind sample but I can't
find what I'm looking for.

I am attempting to make a form for a pick list that is/has a continuous
form that lists all parts available and allows the user to enter a quantity
for each part.

tblOrder
OrderID Autonumber PK
PartID Number FK
OrderNumber text
CustomerName text
Quantity number
etc

tblParts
PartID Autonumber PK
PartCategory text
PartName text
ModelNumber text
Price currency
etc

There are about 7 categories with 400++ parts.

Ideally there would be the order data in the form/page ?? header and then a
continuous subform?? that lists all parts in tblParts with a control to
enter the quantity.

The user could just scroll down the list of parts and enter the quantity
desired.

At this point I'm not even sure if my table designs are close to correct.

As always any thought, comments or suggestions are welcome.

Best regards,
Mike

 

[Mike Painter]

Hi Group,
Access 2007, WinXP

I have looked at the inventory template and the Northwind sample but
I can't find what I'm looking for.

I am attempting to make a form for a pick list that is/has a
continuous form that lists all parts available and allows the user to
enter a quantity for each part.

tblOrder
OrderID Autonumber PK
PartID Number FK
OrderNumber text
CustomerName text
Quantity number
etc

The order table would not contain the partID

That would be in a related table tblOrderItems and presented in a subform on
a form that used Orders.
OrderItemID,PartID, description, quantity, cost with OrderID as a FK.
Extended price, if needed, would be a calculated field.
I usually have OrderItemCost as a field and set it from a parts table. This
way a price change down the road does not mess up the original charges if an
invoice has to be reprinted.

A combo box on the description and or part number will let you fill line
items.
Scrolling through 400 items would be a slow process
This is essentially an Invoice form so check that out on Northwind.

 

[Mike Revis]

Hi Mike.
Thanks for your response.

Your idea makes more sense.

I hadn't thought about it but I guess scrolling through a combo box wouldn't
be much different than scrolling through a continuous form.

I can do the invoice type form you mentioned. I've done similar forms.

This particular form is to be used by estimators to produce a report with
prices to bid for jobs. Then the same report without prices will be used for
the warehouse to pick the parts for the job.

Regards,
Mike