Multiple Table Portal

[AZ Wildcat]

I am building a database for a local EAP (employee assistance program) group that has 23 tables (client, counselor, employer, initial assessment, clinical notes, etc.). I would like to have a main nav page that the counselor can type in the client ID and have a portal display any form that uses that particular client ID in a list with the date and the form title. Although I have been using FileMaker since 1988, this is far and away the largest database I have built. I am probably way in over my head, but that's how you learn (or develop a drinking problem). How do I set this up (if it is possible)? Should I create multiple table occurances and make sure that all have a relationship? Any help would be greatly appreciated. I would be glad to upload the database file if that would help (it is about 1MB).

[Genx]

.. theres no way you can show multiple tables through a portal, however, what you can do is make another table and hoard all id's into it... i put the following file together on the assumption that each of your tables will have a unique serial id system i.e. table1 will have T1xxxx table2 will have T2xxxx. I know this wasnt exactly what you wanted especially seeing as table2 might be holding related data to table 1, but hey

anyway, once you've horded all these id's into the one table... you relate all the table occurances by their ID to this new id hoard table... so that you can draw info from these tables or go to the specific related records in order to goto your desired layout... anywho... just have a look at the file, see if it helps, it should at least start you off in the right direction... or some people may disagree and say the wrong direction, but never the less..

ps. note that after the initial hoarding which you would script... you would just automate record creation within the hoard table whenever you create records within your others using another small script...

~genx

hoard.zip

[Genx]

On second thoughts i just put the sample data in incorrectly... You can retrieve date information etc. from the related records by placing calcs within the join table.

~Genx