Hi guys, I need your help regarding my LO Base form.
Let’s assume I have the following setup:
Table 1: Attributes are ID, Employee Name, PositionFK (Foreign Key, refers to ID of Table 2)
Table 2: Attributes are ID, Position Name, Status
Now, I have a LO form which is showing the contents of Table 1 within a grid. The Position column was created as list box in order to provide a dropdown selection based on the contents of Table 2.
What I would like to achieve is that within the dropdown, only those items of Table 2 are shown which are active (that is Status = 1) BUT in the grid, there should be also those items shown which have the status = 0.
For example:
In Table 1 are the following Employees stored:
ID = 1, John Doe, PositionFK = 1, ID = 2, Jane Doe, PositionFK = 2, ID = 3, Luke Skywalker, Position = 3
In Table 2 are the following Positions stored:
ID = 1, Director, status = 1; ID = 2, Manager, status = 1; ID = 3, Consultant, status = 0
If I’m going to create a new employee, the dropdown of the form should show Director and Manager only. But within the grid, Luke Skywalker’s position should still show Consultant.
What I’m currently able to achieve is that either all Positions are displayed in the grid as well as in the dropdown, or only active items are displayed in the dropdown and inactive positions appear empty in the grid (that means for Luke Skywalker the position column is empty).