One question first: Do you understand the difference between a "table occurrence" and a "data source" table?
In your portal where the row just lights up, Open Manage | Database | Relationships and double click the line linking Ads to this portal's Table Occurrence box. Is "Allow creation of records via this relationship" enabled for the portal's table occurrence?
For more one table occurrences:
Yes, Events2 is a table occurence of the Events table , Ads_contact_contacts is an occurence of the contacts. I did it this way because events_contacts_contacts is an occurence of the contacts table also.
Also, in the portal table (Ads_contacts) the allow creation of records is clicked and the delete records field is also clicked... see the below image. I have included a picture of the link between the ads table and the ads contact table set up and a picture of a list of tables and the list of table occurences. What do you think might help? Thanks again for your help
Your screen shots are too small and blurry for me to read, even if I zoom my browser to 200%.
Did you create your new layout by duplicating an existing layout or by copy and pasting the portal from the other layout?
I'm wondering if the fields inside the portal refer to the correct table occurrence.
Hey, sorry about that... I had to go to photobucket and have the image hosted... thats why its kind of small and blurry. This forum won't let me automatically upload a photo unless it is a new post.
Basically, what I did was copy and paste the portal and everything in it. Then, I went into the fields and set up the portal to pull from Ads_contacts and then each of the fields within the portal to pull from Ads_contacts_contacts such as Name is now (full name) in the Ads_contacts_contacts table... an OT of Contacts. I did it this way because the portal in events pulls from Events_contacts and then the fields within the portal pull from Events_contacts_contacts (it is also a TO of Contacts). I tried pulling the fields forward in aligning them thinking that was the problem because it caused a problem with the buttons for adding a new contact (script that goes to the contact form). Anything else you can think of?
You can try just posting the link to the image on the share site so thta we click to go there and open it. It might make it possible to open and zoom the image there.
I think the issue lies here:
Your portal refers to Ads_contacts, but the fields all refer to Ads_Contacts_contacts. Before you can enter data into a new record of Ads_contacts_Contacts, there must first be a record in Ads_contacts that links the current record of your layout table occurrence: Ads to the new record in ads_Contacts_Contacts. Sometimes this can be done if you enable "allow creation" for the Ads to Ads_contacts relationship AND the ads_contacts to Ads_contacts_contacts relationship.
Alternatively, you add a field from Ads_contacts or use a script to create the record in ads_contacts before you try to enter data into the fields of these new records in ads_contacts_contacts.
Thanks Phil, I am going to try that in the morning. Unfortunately, I'm at work trying to figure this out and we are closing right now due to snow! I hope you'll be around tomorrow to help out... I'll post something back in the am.
Thanks so much for your help thus far... I hope it works!!
Hey Phil, I tried allow creation for both tables in both relationships and it didn't work... then I trial and errored it a bit and still nothing. Then I went back and looked at the relationships between the events_contacts and events_contacts_contacts (the tables that I based the ads tables on and made the relationships like those once again (that was what it was like before)
I tried to figure out if a script was what I needed. But, there is no script on the events form, so I don't think I need one in this form.
I would love to upload a lot of photos that you could look at. I think that is the best way. There are just so many things that could be the problem. Whenever, I think I've figure it out... it still doesn't work. Where is the share site that I can upload multiple photos and you can zoom in and see them? I don't know where that is?
Check out the definitions of the fields used as keys in the relationships between your table occurrences. Most likely, some of those in the original relationships are based on fields that auto-enter a serial number. Make sure that the key fields in the new relationships that you are patterning after the originals have the same field options.
There are hundreds of file sharing sites available that you can use for free. I use http://www.4shared.com/, but many others work just as well.
You could also just upload the file itself instead of pictures. You can use Save a copy as... with the clone option to create a copy with zero records in it for faster upload/download and to protect any senstive data you don't want others to see.
Hey Phil, I checked all of the keys and they seem to be set up correctly. Okay, I'm going to make a clone and upload it to the site you suggested. I'll post again when it is up.
Ok, that took some detective work, but I figured it out eventually.
There is a contact ID field in the original portal that is hidden beneath the full name field. If you add that field behind the first and set it up with the same value list as that selected for the Contact ID field in the original portal, You should be in business here.
This hidden field should be Contact ID and should be from Ads_Contacts. Format it to be a drop down list with values from Contacts.
Full Name should have its behavior set in the Inspector to prevent entry while in browse mode. Contact ID should be set up to allow entry in browse mode.