design issue

Hello,

I have a design issue that I am struggling with. (sorry for the long
post, and thank you for your patience)

Here is the context:

Multiuser, server-based FMP 9 solution for a large membership
association.

3 tables : Members, Meetings, and Registrations (a join table between
Members and Meetings)

On a meeting layout, a user can click on a Portal list of registered
members to see detail information for that member. In my current
solution, I simply have two side by side portals, one is a just a list
of names, the other is a one row portal with all of the detail. I use
Goto Portal Row to get to the correct detail, as they are sorted the
same.

This creates a few problems. One is that the user can scroll in the
detail portal and then it appears that the two portals are not synced
up. The other is that when I navigate between meeting records the
portals do not match up - the detail portal goes back to the first
portal row.

One solution would be to set a temp global key field to the
registrationkey for the particular registration that I want to see
detail on, and then display data based on the relationship between
this globalkey and the registration table. The problem here is that
when I navigate between meetings this globalkey will be the same for
all meeting records and as such will only work for the meeting that
globalkey was applied in last.

The next solution has the tempglobalkey not be set to global storage,
so that each meeting has its own value for the tempkey. The problem
there is that users looking at the same meeting will undo each others
preference as they are working.

So I think I need to link my User table to the Meeting table with an
intervening join table that will store the users current registration
detail that they were looking at.

Its just that when I start thinking about the scripting involved with
this, and the controls that have to start going into navigation, my
head starts to spin.

There must be a simpler solution!? Anybody want to take a shot at
this? Help!

Darren

.

Relevant Pages

  • Re: When is a Quaker a Quaker?
    ... Glenside Friends Meeting ... claim that only members of the RSOF are Quakers. ... >To be accepted as a Quaker one has to be a "member in good standing", ... you are not a Quaker. ...
    (soc.religion.quaker)
  • Re: When is a Quaker a Quaker?
    ... >> Perhaps there are various traditions in regard to formal ... >> that no one distinguishes much between members and non- ... >all appear to accept the corporate worship and the corporate meeting ... reason as if I had claimed that the Spirit is reason, ...
    (soc.religion.quaker)
  • Re: BN Budget
    ... Which IMO is why the Management Group get on and do things, because they are smaller, created by invitation so will be generally of a similar mind on major issues, and can avoid a lot of the formal paraphenalia of EC meetings. ... I am sure we could get small groups of members to look over proposals and offer advice, given the right sort of framework. ... These would be allocated to individuals at the first meeting. ... plus their view on each of the other's personal view - I'll ignore the viewpoints on the viewpoints of the personal views). ...
    (uk.rec.naturist)
  • Re: Historical posting
    ... This posting is intended for informational or conversational purposes only. ... >> out Jan's ridiculous newsgroup trolling and spaming trashy posts" Club ... >> Perks will be discussed at the previous mentioned inaugural meeting. ... >> Meeting to card carrying members of this group. ...
    (sci.med.dentistry)
  • Re: When is a Quaker a Quaker?
    ... >>> any influence in any Quaker meeting, please present your evidence. ... "Not members of a meeting." ... The message was directed to Ian Davis. ...
    (soc.religion.quaker)