Question Relationships and portals
Okay I have a table that keeps case information
I have a table for employees info
I created a join table (joining employees and cases) and have placed a portal on my cases table. The portal show info from the jointable which is showing info from the employees table.
Now the questions
Did I set this up the right way? It works fine just creates a record for every entry made in the portal. Will this fill the database up quickly or is it a non issue?
Now I have created a form letter layout that I need the info from the cases table and the info in the portal lines to show. Does this form letter layout need to be from the cases table or the jointable? How can I write a script to print each portal line?
Thanks for the help