I'm fairly new to Alpha Five and working with both Drop down lists and Pop ups in grids is pretty clear to me, but now some of our users added a new twist that has me stuck.
Users want multiple look up types on the same fields, drop down list in one case and pop up in another. The admin user also wants to view the ID# field value along with the actual text value in the grid when using an admin level ID (e.g. Security level 9).
Source Table/Grid has Eq_ID (equipment ID#) & Eq_Descr (equipment description), target Table/Grid has two related fields I'm using to store same values based on how drop downs & popups function in Alpha Five.
The problem I'm having trying to meet this user request is when users jump between drop down and popup updates to the grid/tables and trying to get the value stored in the ID# field in both cases. Popups seem to store the ID# value just fine, but when the users update the same entries with a drop down list the ID# is stored in the Description field and I'm not sure how to get the ID# field updated properly to match the function of a popup.
The actual lookups are working fine, but I'm having trouble displaying the ID# for the admin user since it's not stored in the ID# field after a user performs a dropdown field/grid update.
Any assistance would be appreciated and perhaps I need to use another approach such as displaying a variable vs the field value?? Looking for help...
Users want multiple look up types on the same fields, drop down list in one case and pop up in another. The admin user also wants to view the ID# field value along with the actual text value in the grid when using an admin level ID (e.g. Security level 9).
Source Table/Grid has Eq_ID (equipment ID#) & Eq_Descr (equipment description), target Table/Grid has two related fields I'm using to store same values based on how drop downs & popups function in Alpha Five.
The problem I'm having trying to meet this user request is when users jump between drop down and popup updates to the grid/tables and trying to get the value stored in the ID# field in both cases. Popups seem to store the ID# value just fine, but when the users update the same entries with a drop down list the ID# is stored in the Description field and I'm not sure how to get the ID# field updated properly to match the function of a popup.
The actual lookups are working fine, but I'm having trouble displaying the ID# for the admin user since it's not stored in the ID# field after a user performs a dropdown field/grid update.
Any assistance would be appreciated and perhaps I need to use another approach such as displaying a variable vs the field value?? Looking for help...