Portal problem!

[snatkins]

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

[RalphL]

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

[snatkins]

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

Sarah

[RalphL]

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.

[snatkins]

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

sarah

[RalphL]

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

[snatkins]

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

[comment]

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).

[Fenton]

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.

[RalphL]

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.

[snatkins]

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

Working now.

Sarah