Hello Dear Community.
I"m creating an inspection App for a buildings suite, where I have a “Corridors” Database with columns ordered like so:
[Building] - [Floor] - [IDCorridor] - [SubIDCorridor] (KEY)
I Then have an “Inspection points” Database, which is used to collect data through a form. I want the users to be “guided” through the form in the selection of where they are doing inspections.
So I do have these 4 columns again, as Enum, pulling data from “Corridors” table with these settings :
- [Building] > Enum/Text - Valid_IF : Corridors Database[Building]
- [Floor] > Enum/Text - Valid_IF : Corridors Database[Floor]
- [IDCorridors] > Enum/Text - Valid_IF : Corridors Database[IDCorridors]
- [SubIDCorridor] > Enum/REF (to Corridors Database) - Valid_IF : Corridors Database[SubIDCorridors]
The Workflow is functionning as expected, and each subsequent field is correctly populated with data related to previously selected field. However the last Enum/Ref (SubIDCorridor) selection a doesnt appear in correct alphabetical/logical order (Buttons or dropdown, same issue…)
This despite the fact that they are correctly sorted in the “Corridor Database”…
Is there any way I can make these fields correctly ordered ?
Many thanks by advance !
Regards .