Jump to content
Sign in to follow this  
iindie

Setting up meetings ....

Recommended Posts

I am a total newbie regarding FMP i am mainly a 4D user so i while i get some of the concepts of SGBDR FMP12 is brand new land to me in terms of design and programming.

Ok we are in the phase of setting up meetings in between different clients

Each clients has his / her own id coordinates etc on the same table , we have created a related table named meetings what we would like to do now is that the event reflects trough a portal on both clients and that the portal shows on each separate client record the meetings occurence. How is it possible with FMP12?

Share this post


Link to post
Share on other sites

Same as with any relational database, you should use a join table to resolve a many-to-many relationship between Clients and Meetings. See an example here:

http://www.fmforums....hp?post/246136/

Another option is to use a checkbox field in the Meetings table to select the participating clients. However, there are many limitations to this method; for example, there is no room to record RSVPs.

---

P.S.

SGBDR (F) = RDBMS (E)

Edited by comment

Share this post


Link to post
Share on other sites

Well the join table method works but i need as well to create the other record on the second participant such as the creation of an invitation to the second target .

So far the data is pulled off fine from the clients table to setup the meeting from the client table i can insert into the portal the first client ID and the second Client ID the portal shows up the proper information. On the other hand though the creation of the revert invitation yet remains to be created when we head to the second's client information the meeting setup on the first client does not show up into the second client's record.

in pseudo code it would look like this

on event data entry and validation (On client1) (Meetings)

A:=Client1

B:=Client2

C:=Date of Meeting

Go to record client 2

Create Records (Meetings)

Client1:=B

Client2:=A

Date_of_Meeting:=C

Validate

That would actually achieve the wanted result we are looking for.

Hence we would have both records on Client1 and the revert record on Client2.

Share this post


Link to post
Share on other sites

I am afraid I don't follow. Suppose the join table is named Invitations; you can create invitations on a layout of Meetings, by selecting the clients in the portal. The same invitations will be also shown on the layout of Clients, and vice versa.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.