I would appreciate some help with related tables and portal setup...
1) I have 2 files: (1) people and (2) documents
2) I would like all document records related to a partiular person to be shown in a portal in the persons record, the records are related by an ID
3) When I try to setup a portal the 'show related records from' part doesn't show the related table I have set-up.
When I go to manage database there is a relationship graph showing the relationship 'people' to 'documents' linking the ID
Please help, what am I doing wrong?
(I have set-up the new file 'documents' as this will potentialy get quite large so I want it seperate from the main 'people' file.)