A Dynamic Portal for An EVENTS database??

[siou]

Hello, and thanks for your help.

So,I have created a CONTACTS database, and I want to create an EVENTS database that links to it.

So, in the CONTACTS file, there would be a portal that shows information from the EVENTS database that allows the user to make choices in the CONTACTS file that would relate to each event.

So, Event Number 1 created in the EVENTS Database, would show up in the portal in CONTACTS automatically, and then the user could choose to invite this contact to this event or not.

Then in the EVENTS Database when I look up this event, it would dynamically store all of the contacts that I have invited to this event, and then I can make other choices in the EVENTS database, such as whether or not they came...etc that would want to show up dynamically in the portal in each CONTACTS database file, so I can know automatically when i see this contact if they are coming to my events or not.

I will also needto be able to choose this group of people in the EVENTS database by this identifying number of the event, and make a mailing list of these people also.

SO, I guess my question is:

How do i make information dynamically show up in an external portal within each contact, so that the user can make the choices that then relate back to the events database, and lets me compile these lists of users?

This is probably so easy...but I cannot break through the logic of this...my head is stuck!

and each way i try, just does not work...help??

this lady thanks you for all of your help and have a great day..

ami

[Fenton]

I'm surprised there's been no answers, though it was Sunday. Basically you need another file, a "join" file in between Contacts and Events, visible in each with a portal.

It would have the primary ID from Contacts and from Events, so it could tie the two together. A record would be a contact-event.

It would not necessarily need many fields, as all info could be shown as related fields from the other two files.

Reports would mostly be done from the join file, which has the information on specific matches between the two.

Create a Summary part for each ID, above the Body. Then sort by ContactID and/or EventID, to show either all Events under the Contact, or all Contacts under the Event; the sort order would decide which showed on top.

The acual set up of data entry involves a portal showing all the choices (or filtered), and another portal showing the actual entries in the join file.

[siou]

Thanks,

So i think i understand.

I would like to ask a few questions though, and thank you so much for your help.

So, i would call The Join File the EVENTS LIST.

1>What would the primary id relationship be from CONTACTS and EVENTS?

Would it be the contact id or the event Id?

2>How would the relationships from EVENTS and CONTACTS to the EVENTS LIST be constructed?

3>Would it be necessary for EVENTS to have an event ID that would then show up in a portal in contacts?

4>Would the Portal in CONTACTS be information from EVENTS or the EVENTS LIST?

5>Would i make the new event in the EVENTS database or in the EVENTS LIST database?

6> Is the information in the EVENTS LIST in a portal or just lists?

Then the QuestionIS:

How would i make it that there is a record in the LIST database that notates that choice?

Would the choice of invited or attended exist in the events or just in the EVENT LIST database?

Note:

I would like the user to open EVENTS and create all the information that is about the event,

then go to the CONTACTS database, and in the portal that would show up there, make each individual choice for each person whether or not to invite them to that event...basically check a box that they want to invite them, and then be able to go to thisnew EVENTS LIST database and compile a list of all the people that they invited, and then choose whether or not the person came, and then this information is also dynamically shown up in the CONTACT file so that whenthe user looks up this CONTACT they know if the person came or not?

Sorry if i sound confused...i just really want to do this right!"

thanks so much...

[Fenton]

OK, I hope you're still monitoring. I'm afraid I missed your return post yesterday.

Rather than explain in words, I've built the world's smallest 3 file system example (actually hacked it down from another example).

People_Events.zip