Form with Header and Detail Lines

  • Thread starter Thread starter mau
  • Start date Start date
M

mau

Hi,

I have 2 tables ORDER_HEADER and ORDER_LINES. I want to create a for
where the top part is fields from ORDER_HEADER and the bottom half i
multiple lines of ORDER_LINES that relate to the header. When i creat
the form with the wizard and add both tables i only get 1 set of field
for ORDER_LINES. Do i just copy and paste the ORDER_LINES fields fo
additional lines?

Basically its an order entry screen, so i can enter order number o
ORDER_HEADER and multiple products in ORDER_LINES and then be able t
update one record to ORDER_HEADER and multiple records to ORDER_LINE
on the one form.

Whats the best way to go around this?

Thanks

Davi
 
mau said:
Hi,

I have 2 tables ORDER_HEADER and ORDER_LINES. I want to create a form
where the top part is fields from ORDER_HEADER and the bottom half is
multiple lines of ORDER_LINES that relate to the header. When i create
the form with the wizard and add both tables i only get 1 set of fields
for ORDER_LINES. Do i just copy and paste the ORDER_LINES fields for
additional lines?

Basically its an order entry screen, so i can enter order number on
ORDER_HEADER and multiple products in ORDER_LINES and then be able to
update one record to ORDER_HEADER and multiple records to ORDER_LINES
on the one form.

Whats the best way to go around this?
Click to expand...

I can see how you would come to this way of thinking, but you actually need
two forms. One for your header table and one for your line detail and then
you put the latter as a subform inside of the former.
 
Back
Top