Tables Hidden

[sousal]

Hello, I am wondering if there is a way to have the app show an option to enter data between two tables I have created. 

For instance, they first see table 1 and 2 and if they were to pick 1 they get checklist 1, whereas if they pick table 2 the get checklist 2. 

[dbaum]

You may not have the right data structure in the first place. Nonetheless, what you describe is possible. Here's one technique.

• In a Users table or in User Settings, create a column that allows selection of table 1 or table 2.
• If you used a table, create a view that includes that column. If you used User Settings, the Settings view provides what you need.
• Create separate views for checklist 1 and checklist 2. In each view, enter an expression in the Show if property that returns true if the column you created contains the applicable value. For instance, in the view for checklist 1: USERSETTINGS("Checklist") = "Checklist 1"