Question Multi Line Order Form, just won't work

[AjidMB]

Hi,

I'm probably making a novice mistake here.

I want to create a Multi Line Order Form

at the moment I have

Accounts TBL
Products TBL
Orders Tbl
Order Lines TBL

My idea was that The Orders tbl would have. Order Number (ID), and Account Number, Order Date, etc.

Order Lines Would Be ID, Product Code, Product, qty and value. and a linked Order Number to the order number on Orders TBL.

Now I Have A form for input to the "Orders tbl" with a subform as a datasheet for "Order Lines TBL"

How do i make sure that in each record for
"Order Lines TBL" on the form that the order number that's linked matches the order number on Orders Tbl?

i.e i want somebody to open up a form and fill in all the data without having to manualy enter the order number from the top of the form in the order number field for every line in the orders line section?

Or am I going about this completely the wrong way??

 

[Trevor G]

Welcome to the forum AjidMB,

With the main form and subform you open the main form in design view, then you look to open the properties of the subform to show you Link Master Field and Child Field then just match the to fields and that should work.

 

[gemma-the-husky]

the users do not enter the main order number on the order lines. you arrange for the form to do this automatically, which it will do if you manage this as a form/subform

in some cases you have to do it "behind the scenes" with a tiny bit of code.

either way - the users do not need to enter the data.