Depending on the answer, this is either a Form or a Query question.
I am creating a DB from a linked table to monitor and record production. I CANNOT change this original table (SalesOrderLine). I need to filter my main form (form_SalesOrderLine_qry) based on a field (CardComplete) found in another table (tbl_NotesComplete) that I created based on the PK in my linked table. The2 tables have a one-to-one relationship.
My question is how can I relate the two?
My 1st attempt I first added my CardComplete field to my SalesOrderLine_qry, upon which my form is created. It worked wonderfully but my query did not include newly entered orders found in my linked table because they were not yet in tbl_NotesComplete. I played with the relationship join type, to no avail. Perhaps I didn't do something correctly?
My second attempt took the CardComplete field out of SalesOrderLine_qry, which allowed for all orders from the linked table. I then created a subform (subform2_tbl_NotesComplete) on form_SalesOrderLine_qry. This allows me to see the information but I need to filter form_SalesOrderLine_qry based on the CardComplete field, which is located in the subform. I found some information about changing the RecordSource but before I got too far into that, I thought I would seek professional help.
Attached is a picture of my form.
I intended to finish the project sooner, but I am learning as I go. I am leaving this job in just a few weeks and really want to leave a finished product behind. Your help is very much appreciated.
Mindy