1 Reply Latest reply on Mar 16, 2015 9:24 AM by philmodjunk

    Filter Value List based on Relationship - dumb question



      Filter Value List based on Relationship - dumb question


      ok I'm having a serious brain fart here and can't null this out for some reason.

      I have two FILES.. not just two tables.. but two files.

      One file is called Jobs and consist of all the company's current and completed job numbers. Job numbers are divided up into Divisions (Departments if you will)

      the other file is the Shipment Log. In the shipment log, when they create a new log entry they can pull from the Job Number list.. no big deal. Easy

      But for the life of me I can't figure out create the relationship so that it only shows.. Job Numbers that are OPEN and in their Department.

      I have the relationship like this

      Shipment::fkJobID = JobNumbers::pkJobID
      Shipment:filterStatus = Job Status
      Shipment::filterDivision = Job Division

      whereas filterStatus is a Calculation field simply "Open" and the filterDivision is a Calculation simply "Transportation".

      Setting up the Value list using this relationship still brings in all the Job Numbers.

      I've tried it every which way but loose and I'm probably doing something dumb. It is monday after all.