Need help with privilege set
I have a database that has about 10 tables, many layouts and many portals within those layouts. I'm currently attempting to give privileges to access certain portions of the database to certain employees, but have hit some stumbling blocks.
My example is that I have a table called Patient Information. From a layout of this table I have a portal to a seperate table called Broken Brackets (I'm an orthodontist). I can set up privileges to allow access to the PI table and to the BB table, but the portal never seems to work. Is there an easy explanation for how this is supposed to work? I'm sure I'm missing something easy.