I have a table for my Contacts - in this table, there is a portal which shows Communication History - with two fields: COmmunication and Date. THe relationship I have created between the tables is Contact Name. I have many other portals throughout my database that work, yet for some reason, the same communication line is showing up in ALL records - so I see the same text in each portal! What's up with this?

note: I only add new records into the portal - then this creates the new record in the Communication History table - shouldn't it automatically enter the Contact;s name if I am entering into that specific Contact's portal?

Help me please!!!

THanks, sarah

This usually means that the fields are using a different relationship than the portal. Go to layout mode and check the fields.

The Fields and the portal are all using the same Relationship - any other ideas?

Sarah

Check the fields that all of them are inside the portal row. If this doesn't work post a copy so we look at it.

Thanks for going through all of this - what do you mean by "post a copy" - of the actual database?

sarah

Make copy with a few dummy records and attach it to your post. Did you get it fixed?

No, I haven't fixed it - I feel like my join Relationship might be the problem - but I am really kind of perplexed because i made the relationship the way I've made so many others.

I am attaching a copy - if you can help that would be great! (I've erased the majority of the database, and just included the table I am having hte problem iwth. The portal is called "Communication History"

sarah

SNDBCopy.fp7.zip

1. Make the calculation field Contact Full Name =

First Name & Last Name

i.e. use ampersand instead of plus sign.

2. Set the result of the calulation to Text.

3. I would suggest that in the relationship definition, you uncheck the options to allow creation of records and to delete records in the CONTACTS table (on the left side).

Your match field is a calculation, with result number. It's 0 for any record. The result should be text. Also, you've got:

First name + last name

It should be:

First Name & " " & Last Name

"+" is only used for numbers, "&" is for text.

I have looked at you sample file. I missunderstood your problem. Your problem is in the definition of the field full name in Contacts. You had this as Full Name = First Name + Last Name, it should be Full Name = First Name & " " & Last Name. You also had this a number field instead of a text field. This is a bad choice for a key field. A field Contact ID which is an auto-entered serial number would be a better choice.

You have the relationship set to create related records in both directions. It can't do that. As you have the key Full Name a calculation in Contacts.

Thanks to everyone - that was a totally negligent calculation mistake on my part - oops!

Working now.

Sarah