Generate Order Fom - Help

[johnob]

Hi all,

Im would like to generate prescription order form, so that I can order 10 line items at a time. But have no idea where to start.

I have the following tables,

Suppliers
---------
SupplierID
SupplierName
SupplierContact
SupplierAccount No
SupplierPhone No

Order Form Header
-----------------
SupplierID
SupplierName
SupplierContact
SupplierAccount No
SupplierPhone No
Date

Order Items
-----------
OrderID
ItemID
Item Name
Item Description
Item Size
Item Code
Item Qty


Items
-----
ItemID
Item Name
Item Description
Item Size
Item Code
Item Qty


Can anyone help where to go from here, or have a simple db sample I could look at

Thank you

John

 

[burrina]

Check out this site. http://www.databaseanswers.org/data_models/


HTH

 

[spikepl]

search for access templates. microsoft has a whole bunch of them