Help Needed: Creating a Filtered Drop-Down for Entry Form Based on Product and Entry Tables

[mayankkshah]

Hello everyone,

I need some assistance with implementing a drop-down for the EntryNo field in a form for the Entry table. The drop-down should display distinct ProductId values from the Product table, but only where:

1. MaterialType is 'A' or 'H'.
2. The ProductId is not already present in the Entry table's EntryNo column.

Example: If the EntryNo column in the Entry table already contains 101-100 and 101-106, the drop-down should only show ProductId values with MaterialType 'A' or 'H' from the Product table, excluding 101-100 and 101-106.

Additionally, once a record is created with a ProductId from this drop-down, that ProductId should no longer be visible in the drop-down when creating a new entry.

I would appreciate any guidance or examples on how to implement this feature. Thank you in advance!