Ask Your Question

Ferineum's profile - activity

2018-01-16 14:11:53 +0100 received badge  Famous Question (source)
2017-05-25 19:03:38 +0100 received badge  Organizer (source)
2017-05-25 19:02:49 +0100 commented question [Base] Display in Listbox only "active" items

Okay, I tested a litte bit by myself and now I've got the following macro in place (in on Mouse Button pressed Event):

2017-05-25 19:00:23 +0100 commented question [Base] Display in Listbox only "active" items

Okay, I tested a litte bit by myself and now I've got the following macro in place (in on Mouse Button pressed Event):

2017-05-25 15:57:34 +0100 commented question [Base] Display in Listbox only "active" items

Okay, I tested a litte bit by myself and now I've got the following macro in place (in on Mouse Button pressed Event):

2017-05-25 15:57:26 +0100 commented question [Base] Display in Listbox only "active" items

Okay, I tested a litte bit by myself and now I've got the following macro in place (in on Mouse Button pressed Event):

2017-05-25 15:57:04 +0100 commented question [Base] Display in Listbox only "active" items

Okay, I tested a litte bit by myself and now I've got the following macro in place (in on Mouse Button pressed Event):

2017-05-25 12:23:08 +0100 commented answer [Base] Display in Listbox only "active" items

Thank you for providing this answer. I also like EasyTrieve's approach and I'm also thinking about writing a macro. But

2017-05-25 12:21:29 +0100 received badge  Supporter (source)
2017-05-25 12:21:26 +0100 marked best answer [Base] Display in Listbox only "active" items

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).

2017-05-25 12:21:26 +0100 received badge  Scholar (source)
2017-05-25 12:19:26 +0100 received badge  Notable Question (source)
2017-05-14 19:21:25 +0100 received badge  Popular Question (source)
2017-05-14 18:16:14 +0100 received badge  Student (source)
2017-05-13 15:52:16 +0100 edited question [Base] Display in Listbox only "active" items

[Base] Display in Listbox only "active" items Hi guys, I need your help regarding my LO Base form. Let's assume I have

2017-05-13 15:51:48 +0100 asked a question [Base] Display in Listbox only "active" items

[Base] Display in Listbox only "active" items Hi guys, I need your help regarding my LO Base form. Let's assume I have