Purchase order form (1 Viewer)

[Gismo]

Hi all,

I need to create a purchase order form, well, I did, and it is not working out as I would like it to be
I am actually not sure how it should be formulated and what the standard out there should be
I downloaded the Northwind DB but the form is very basic

I have quantity and also weight inputs with unit cost and currency
I also have some components which out of the norm with abnormal volumes and I prefer not to create a part number for each so in the purchase order in need to enter the unit of measure

Could someone please point me in a direction to get a few samples?

 

[Minty]

It's pretty much identical to an invoice layout.
tblPOHeader - PONumber(Can be the autonumber PKID if what it looks like doesn't matter), SupplierID, PODate, RaisedBy etc etc
tblPOLines - PO_LIneID(Autonumber) , PONumber_FK_ID (LinkBack to the header), ProductID, LineDescText, Qty, UnitOfMeasure, UnitCost, etc

With the product ID you have one called Misc. and it has no description or default units etc, and you simply enter that in the LineDesctext. Otherwise fill it out automatically from the Product Id's description (Combo hidden columns).

Whilst this slightly goes against normalisation, it allows for the free text part of the issue to be stored.

 

[Pat Hartman]

I look at Excel and Word templates for ideas on forms.