I forgot to mention:
Right now, with the way the relationships are set up, changing one portal row affects the same change in the same row of all portals (as they are not uniquely identified fields at the moment)
I see what looks like three portals in a single tab. Are these three portals to Exercises?
Are they filtered portals to limit different entries to different portals?
What is the purpose to the Parameters table? (which doesn't yet appear to be part of the current issue...)
The three portals are all to "Parameters". They are currently unfiltered. I've been reading up on filtering them, but haven't succeeded at finding a similar request thus far.
All the fields in the portals are from the parameters table (D1_End_ExName; etc).
The Exercise table was used to enter exercise information. Once the exercises are in the database; the exercise names are put into a value list. The value list is then assigned to the D1_End_ExName field in parameters (photo attached)
Did you edit your original screen shot before posting? I see no way that screen shot could be possible for the layout that you have designed without portal filtering.
You'd see the same list of exercises in each table as you are listing the same records in each portal unless a portal filter were used to control which records appear in each column.
There are two ways to get three different sets of records from the same table for your three portals:
1) A portal filter could limit the first set of records to "cardio" records
2) Three different relationships could be set up to the same Parameters table occurrence. An added pair of match fields would be different for each portal so that you match to different sets of records in each portal.
But now that I take a closer look at your relaitonships, I see additional potential problems as your relationships do not look correct in the screen shot that shows them.
a) isn't this data in these portals for a specific client rather than a specific trainer? Your current relationships would appear to show this data for a specific trainer. What does one record in the "morfit trainer" table represent?
b) There's a disturbing lack of "crows feet" in the relationship graph. What is shown shouldn't permit multiple records in the parameter portal as they show "one to one" relationships everywhere but two the globals table.
Thanks Phil. I took the screen shot seconds before posting.
One record in the "morfit trainer" table represents one exercise template (or workout program).
I apologize for the disturbing lack of crows feet :) Your questions have brought up a couple aspects to FM that I'm probably not familiar enough with to intelligently troubleshoot (or even articulate) my current predicament. I will spend some more time educating myself on relationships; then tackle this portal issue once again.
Thanks Phil. Back to the Forums!!!