Unanswered: Populate subform with data from a table matching given criteria
I am attaching .mdb file plus a word doc file with clear explanation, screenshots, and an example of what the result should be .
Goal : After entering Port Of Loading and Port Of Discharge on main form , I want to click label “POPULATE” and it runs an event that will look up FCA table for records meeting criteria :
Port Of Loading (main form) = POL (on FCA table) AND Port Of Discharge (main form) = POD (on FCA table). Sub form would then be populated with all records on FAC meeting criteria and table Quot1_OceanFreight would save these records. This is a one to many relationship so this event shall return more than one row to subform grid.
Please use POL = PTLEI and POD = GBFXT once it contains more than one record on FCA table.