This topic is locked

Drop-down value

7/26/2017 2:27:24 AM
PHPRunner General questions
P
phpcmk author

Hi,
I have created 2 tables:

  • TableA (Attribute: Client, Department, Project) => Project is using drop-down from "Lookup Wizard", the link field is from TableB(Project) with dependent from TableB(Department)
  • TableB (Attribute: Department, Project)

    Example:

    Value of TableB
  • DepartmentA, A001
  • DepartmentA, A002
  • DepartmentA, A003
  • DepartmentB, B001
    Question: I would need the drop-down list does not appear the project value if it already used by the same client & department in TableA.

    Example:

    Exist TableA = Peter, DepartmentA, A001. Thus, if a record is keyed Peter, DepartmentA, the Project drop-down value should list only A002,A003.
    Can someone kindly help. Thanks.