Lost my way!

[Slap]

I've reached that point where I can no longer think straight about a form issue, despite many searches :banghead:

Here's what I am trying to do:

I have a team working for me who are responsible for taking an action on multiple records once a certain stage has been reached. I've got all the data updating issues clear and can get these from ODBC sources and move them around into some tables and queries to produce a report for the guys.

My next step, and here is where I am stumped, is for an end of day form where a comment can be made and archived against records not processed for what ever reasons.

The form should have as selection criteria:

SHIP_TO (Address)
METHOD (Sea, Air etc)
COUNTRY (Argentina etc)
REASON (Building shipment, inadequate value etc) ** This pulls from tbl_REASONS,which simply lists agreed reasons **

And for data lines (against which I will eventually record the reason and some dates)

COMMENT_FLAG (Yes/No tick box)
DELIVERY_ID (Shipment number)
SHIP_TO (As in the header)
METHOD (As in the header)

So they select a record in the header and can then associate a REASON against all or some of the lines relating to the header data by ticking the Yes/No COMMENT_FLAG.

I have the data lines in a table, tbl_FORM_DATA and the header info in a grouped query qry_FORM_HEADER (except the REASON) but can I get a form/sub-form situation to work? Can I 'eck as like

Normally I am not getting a master / child link in the data field of the properties. Is there a trick to this or maybe a better way to do this? I have a one-to-one relationship on SHIP_TO field between the table and the query.

Thanks in advance for any help you may be willing to provide

 

[Slap]

Don't you just hate that, 10 minutes after the brick wall I get the link I needed

Thanks to Bob Larson's help on another post. My issue was not correctly selecting the container!

Now I have I can work on adding some cascading combo boxes as an alternative and then adding the update SQL to an action box.

Link: without the spaces

http : / / www . btabdevelopment . com / ts / ewtrhtrts