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...