May 06, 2010; 01:56
David Thorp
separation model context conundrum
Greetings all,
Here's a curly one. If anyone has any ideas, I'd be really keen to hear them ;)
I have a separation model. ie. Separate View and Data files.
In the view file I'm on a layout that is based on table occurrence that is based on one of the tables in the data file ... you got all that?! :)
I'm doing various things with a portal on that layout, including filtering it based on certain criteria (FM11 portal filters). There is nothing in the data file to tell the data records what's going on, all the calculations and everything are being done in the view file.
I need to show a particular graphic on every row of the portal, but it needs to be a different (calculated) graphic, based on certain criteria, mostly to do with the portal filter.
Normally, to show a different value in a field in a portal row, the field has to reside in the table that corresponds to the table occurrence that the portal is looking at and the calculation to decide what shows in that field needs to be calculated from the context of that table occurrence.
However, I can't see any way to make that table occurrence aware of the portal filter, since the portal filter is entirely calculated from the context of tables in the view file.
To add to this, it's possible that I may have two or more identical portals, viewing the same relationship, but each one will sometimes need to be filtered differently at the same time, again meaning that i can't calculate the graphic based on data in the data table, because the calc that needs to decide which graphic to display is dependent on the portal filter.
So... i've got some complex context issues here. Does all that make sense, and anyone got any ideas?
If it doesn't make sense, please let me know and i'll try to clarify further.
Thanks!
David.
--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/