Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012
    Location
    Maia - Portugal
    Posts
    3

    Unhappy 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.

  2. #2
    Join Date
    Oct 2012
    Location
    Maia - Portugal
    Posts
    3
    guess I posted a tricky one that no one can sort it out or even have a clue . So sad to me.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •