Related Table Data not Visible on User Accounts
Hi. I'm new to FM, and I'm stuck on what seems like a simple thing: I have a layout that displays data from related tables when I'm logged in as the administrator (all access.) When I log in as a user with restricted access and a defined privilege set, however, the layout only displays data from the table the layout is based on, not any of the related tables. I went to Manage--> Layouts and changed the "Show records from..." option to a different table and then it shows data from that table and not from the original table, so I don't think it has anything to do with the way the privileges are defined. How do I get the layout to display data from all related tables in one layout while signed in as a user.