Hi there. So on a ‘show form’ screen, it gets the columns from the correct table (but I can’t define the table any longer when clicking the “add” button I’ve defined; Why?). But when I try to set the default value of a field, it wants to take it from the user table. Why? I’m thinking it’s related to the “work-around” I put in place to enable the ‘add’ button to be visible when no records existed for a user. So I set the detail form source to be the user table. But no matter what other table I set it to, then, it seems it is going to work correctly for the content of the screen, but it will try to set the “default” values from the detail screen’s default table (in this case user’s tab).
Well, now something is certainly wrong; because I reversed my “work-around” and there are no visibility conditions on the add button, and there are records in the table that is set as the default for the detail page. But there is no add record button visible.
And because I knew you’d ask; there are no conditions at all on the show form button…
Check if the table is defined on the action of your form button.
This is expected behavior. The screen that contains your Add button is sourced from the user table. The form is then able to retrieve default values from that source table, or you can pass along values through the form using Value components. Your tab happens to be sourced from the user table, so what you are seeing is values from the user table. Whichever table contains the form button will be the table that provides values you can use. It gets more confusing because you are building your screens against the user table. That’s another reason I tend to just create separate single row tables for my tabs. It’s cleaner, easier to understand, and has some addition benefits down the road.
So you are certain that the table that is the source of your mileage tab contains rows that are accessible to the user, and you don’t have any filters on the tab screen? Check the screen filters. Not the button visibility.
Thank you for your detailed analysis. I am certain that there are rows available and I have no filters. I have not had a chance to look at it again today.
1 Like