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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    Lee Smith 
×

Important Information

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