invitations

[Raymond Gonzalez]

Hello! im having a problem.

Im making a file of invitations. For example. In my layout i have to write who invited me, and down to be displayed every person that i have invited. The problem is that one person can be invited by one or more persons, how can i do that? please, somebody help me.

[Raymond Gonzalez]

To understand it better see it as recording memberships. Im a member, i was invited by one or more persons, and I want to also have maybe a portal showing all the persons that are a member because i invited them. The point is, that one member can be invited by one or more persons. Thanks.

[mr_vodka]

Is this an Amway type of level marketing setup?

If it is, then the structure might get a little moer complicated. If not, then I think you can just use a table for your contacts, and an invitation table where you select the organizer and then have a portal to display the third table for invitees.

[Raymond Gonzalez]

Its not really like Amway, its like this. I was invited by one or more persons, I can invite one or more persons. I need to display who invited me and who i invited, i dont really know how to do it. Can somebody tell me step by step or give me an example? please! thanks!

[mr_vodka]

Can there be more than one invitation from a user? I do not mean if a user can be invite more than 1 person or if more than 1 person can invite others. I mean, can a user invite people again and again and do you want to store each time they invite someone in a seperate invitation record, or it is just a general structure to see who invited who.

[comment]

Basically, you need two tables: People and Invitations. The Invitations table has fields for FromPersonID and ToPersonID.

Define two relationships from Persons to two separate occurences of the Invitations table:

First relationship:

People::PersonID = Invitations::FromPersonID

Second relationship:

People::PersonID = Invitations 2::ToPersonID

Place two portals on a layout of People - one will show the invitations this person has sent, the other invitation received.

It gets a bit more complex than this, because each occurence of the Invitations table needs another occurence of the People table attached to it (to supply the person details for the portals). So in the end, you will have two occurences of Invitations and three occurences of People on the graph. But this should get you started.

[Raymond Gonzalez]

i just want to be able to write who invited me, one or more persons, and that automatically, in the layout of those who invited me my name to appear. Thanks!

[Raymond Gonzalez]

can i keep adding to a portal? because of what i said, one person can be invited by one or more people, there wont be any problem with that? thanks!

[comment]

Yes, that's exactly what will happen (or almost exactly). If any or both of the relationships are allowed to create new records (i.e. new invitations), you can select (rather than write) the person/s who invited you in one portal, and when you switch to their records, your name will be included in the other portal.

[Raymond Gonzalez]

How did u get "invitations 2"?

[Raymond Gonzalez]

i got it! thanks!