Don't understand why you need a second portal at all. With a layout based on Patients and a portal to admissions, you can place a popover button in the portal row and put any fields from admissions or procedures in it that you want.
No scripting, portals or portal filters would be needed.
hi, Philmodjunk, thanks for replying!
But as I know there ar not popovers in FM12Pro Adv. Maybe you refer to script to open "related records in another window"? sorry if I'm wrong!
I'd add the fact that a "patients" has one or more(15?) "procedures". where should I place the "procedures" portal, in order to create patients history, with the magic button, to show the rest of "procedures" data?
I have a layout of "admissions", as a list where there are 12-15 fields between all of three tables. but being based on the join table, every row reppresents an admission, but I can not have shown all procedures, wich makes me think that I have to make a similar file but with the procedures as join table. Am I right? I appreciate your time and explanations! ciao!
No, I meant a popover button as I missed the FMP12 imfo.
But a portal to admissions can list all all procedures for a given patient. The row of a portal based on admissions can include any field that you need from admissions or procedures given the relationships you have described.
My aim is to create a layout based on patients, in order to create clinical history, in this case admissions and procedures with some their data(fields). but, in the layout based on "patients" table, the portal of "admissions" that contains two fields, "admissions dates" and "procedures dates", does show, let's say, five admissions with seven procedures, which is unreal.
sure, I lack quite some basic notions, but trying to follow step-by-step what i see and learn, some hints here may open new windows, as it has already happened, thanks to you philmodjunk, sincerely.
I'm not sure what you are trying to achieve here with the portal that isn't working for you.
On option is to expand you portal to include the additional fields. The portal row can even be configured into a mini-form instead of the more typical "tabular" format that is the default for a portal. You could modify this further to show only the records for a selected admission if you want.
Then you can also use a button in the portal row that uses Go TO Related Records to open up a new window showing the records from the portal in the window that shows the additional info. A constrain found set or find matching might be added to limit the set to just those with the same admission ID.