Creating view using dynamic choice field
I have a database of equipment. The equipment is in various locations of the building. All the locations are stored in a separate table 'Locations' with two fields: 'Main location' and 'Sub location'. (Example: Main location: Building three, sub location: Third floor).
The location of the equipment is entered in table 'Equipment' in two fields: 'Location' and 'Detailed Location'. The field 'Detailed Location' is a dynamic choice field depending on the entry in the field 'Location' and taken from field 'Sub location' from table 'Locations'. This works fine.
Now I want a view on the form of table Locations so I can see all equipment in a specific combination of 'Main location' and 'Sub location'. I can't get it to work, or I have a view showing the equipment in 'Main location', but not specific on the field 'Sub location'. How can I include a dynamic choice field in the select statement for a view?
2 replies
-
This is part of a steep learning curve
. Just studied a tutorial and as there is no link between tables using a dynamic choice field, it is not possible to do. I modified the database to a link to get it to work..... -
While a dynamic field is not a direct link to a record, it is a soft link cause you have the exact record Id of the selection.
That means you can use the record() command to get the record selected and then you can access any data from that record.
let detailedLocationRecID := record(Locations, number('Detailed Location')
Content aside
- yesterdayLast active
- 2Replies
- 20Views
-
2
Following