First time using AppSheet, so sorry if this has already been covered somewhere
I’ve got 3 mySql tables, one called ‘Locations’, one called ‘Devices’ and one called ‘DeviceTypes’
The setup (Obvious) is each Location can have many Devices, and each Device is linked to 1 DeviceType
Everything is properly viewable, but I’m having trouble referencing more than 1 table. The ‘DeviceTypes’ reference keeps showing me the ‘Locations’ table whenever I click on the link.
I tried to manually enter the key via mySql into the ‘Devices’ table for the correct ‘DeviceType’, and it shows the ‘Locations’ + the key I manually entered at the bottom of the list…
I even tried creating Slices from the table(s) to be referenced with the same result (Assuming the column name has to match the referenced table/slice name)