N
need help
I have an ‘Order’ Form which has a subform ‘Freight Detail’ table where I
enter details of freight (cartons, pallets etc) for each order.
I have also created another form ‘Freight Invoice’ which has a same subform
‘Freight Detail’ table.
Using this form (when I get the invoice from transport company) I want to be
able to apply the details of the freight (which I entered using ‘Order’ form)
to the ‘Freight Invoice’ table.
So [Freight Detail] is a sub form of two separate forms.
[Order] --> [Freight Detail] <-- [Freight Invoice]
Order # Order #
Con note
F Invoice F Invoice
But when I try to pull up freight detail data (using various methods like
combo box etc) In the 'Freight Invoice' Form it comes up with message “Cannot
change record because related Record is required in 'Order'â€. I think I am
having trouble because the [Freight Detail] is already a child/subform of
Order table that has data in it .
One Order can have multiple freight details (connote) &
One Invoice can have multiple Freight details (con note)
Is there any around this problem. Thanks
enter details of freight (cartons, pallets etc) for each order.
I have also created another form ‘Freight Invoice’ which has a same subform
‘Freight Detail’ table.
Using this form (when I get the invoice from transport company) I want to be
able to apply the details of the freight (which I entered using ‘Order’ form)
to the ‘Freight Invoice’ table.
So [Freight Detail] is a sub form of two separate forms.
[Order] --> [Freight Detail] <-- [Freight Invoice]
Order # Order #
Con note
F Invoice F Invoice
But when I try to pull up freight detail data (using various methods like
combo box etc) In the 'Freight Invoice' Form it comes up with message “Cannot
change record because related Record is required in 'Order'â€. I think I am
having trouble because the [Freight Detail] is already a child/subform of
Order table that has data in it .
One Order can have multiple freight details (connote) &
One Invoice can have multiple Freight details (con note)
Is there any around this problem. Thanks