Thank you for your reply.
I have a major issue now. The “Surgery List” table has 6 columns, [Surgery Title], [Specify - 1], [Specify - 2]… and so on. They work for a dependent dropdown menu, so each surgery title has specifications spread across the other 5 columns that will be shown in the dependent dropdown menus.
Now I was using this “Surgery List” table’s 6 columns for only a single form based on a table called “Surgery Logbook”. But then I wanted to create another table called “Endoscopy Logbook” in the same app and I wanted to use the same “Surgery List” table’s 6 columns to specify endoscopic procedures in it, but as you can realise, I wanted the “Endoscopy Logbook” table’s [Endoscopy Title] to only fetch endoscopy related data and leave the surgery titles behind.
At the same time, I wanted the “Surgery Logbook” table’s [Surgery Title] column to fetch data from the “Surgery List” table’s [Surgery Title] leaving behind the endoscopy titles in it, and to that, I wrote
Surgery List[Surgery Title]-List("Colonoscopy","Sigmoidoscopy","UGIE","ERCP","Rigid Sigmoidoscopy","Proctoscopy","EUS"), but the issue is, eventhough those values were taken out of the list, the dependent dropdown stopped working for the [Specify - 1], [Specify - 2]… columns! Guess, the moment you write an expression like that, the dependent drop downs stop working.
So I guess I have to create a different table for the “Endoscopy List” similar to a “Surgery List” and then get the “Endoscopy Logbook” to fetch data from that to work the dependent drop downs. My issue is, by doing that I increase the number of tables in the app and it feels that the app sync times are increased when the number of tables increases!