0

I have a form and lookup field in it named PI Code. PI code comes from another table and this table has a checkbox field named active. MY lookup field needs to display only the active fields. How can I do that? If I copied onlookup event handler from the PI code and try to filter, how can I assure that inactive records won't be displayed? I would be really appreciated it if anyone can help me.

Thanks and regards...

lookup filed

Parent table

Granger
  • 21
  • 1
  • 10
  • 1
    What type of lookup is this? Provide your code. You would just modify the lookup query to include a range/value of something like `[...].addRange(fieldNum(YourTable, Active).value(queryValue(NoYes::Yes));` – Alex Kwitny Jul 13 '21 at 18:18
  • Glad to help, I'll change the comment to an answer. – Alex Kwitny Jul 20 '21 at 17:25

1 Answers1

1

Modify the lookup query to include a range/value of something like:

[...].addRange(fieldNum(YourTable, Active).value(queryValue(NoYes::Yes));

Alex Kwitny
  • 11,211
  • 2
  • 49
  • 71