Sub-order form for orders

[MattCass87]

Hi all,

Please see images attached, layout currently crude and incomplete as I try to work out the process. If anyone could explain it would be most appreciated.

I want my item details form to automatically understand that its related to a particular order detail and order.

I cant work out the correct wording to google search it. Do I need a macro on a button to tell it to reference the order its currently viewing when the new item is requested.

Thanks

Matt

 

[isladogs]

In the 2nd image you have a subform. Link this to the main form using orderid as the master/child fields.

That should get you started though I'm sure there's more to do.
Unclear what the 3rd image is showing.

 

[arnelgp]

on your Item Detail Form,
you should use Listbox to
show All Orders for a
particular Item

The rowsource should be:

Select Distinct OrderID From [Order Detail]
Where ItemID = Forms![Item Detail]![ItemID]

you need to Requery the Listbox
everytime you Edit or Add Item on this form.
you can do this on AfterUpdate Event of the
ItemID control:

Private Sub ItemID_AfterUpdate()
Me.ListOrders.Requery
End Sub