Hello,

To give a little background on what I doing, I am developing a database to track alumni who have started companies. The alumni and companies each have their own table and I created a many to many relationship with a portal on the alumni layout that displays the company information.

On this portal I have a button that opens a new window so that a user can insert a new company. This is needed so that they do not need to switch back and forth between company and alumni layouts. The script for the button is as follows:

New Window

Go to Layout [New Company]

New Record/Request

Go to field [Company Name]

The problem is the following. I need the new record/request call so that the user can enter in information for the new company; however, this call not only makes a new record in the pop up window, but a new record in the alumni layout. This creates a duplicate entry for any alumni that has a new company. How can I avoid this? Thanks for all the help,

Dan

Edited August 1, 200718 yr by Guest

Post a copy of your file or relationship.

Check that the New Company and Alumni layouts *really* point to the correct table occurrance.

Also, do you have any event-triggering plugins in operation? I ask because the Ne Record step can only make one record in one table, unless something else is being caused to happen.

Thanks for the help. I just started using FMP about 2-3 weeks ago, so I am still very new and do not know all of the nuances yet. Thanks again for any help you can provide. - Dan

Alumni_Company_Database.zip

Your "New Company" layout is showing records from your Personal Information table but with fields from the related Companies table. So the New Record bit makes a new Person record, while typing in the Company field on that layout makes a new Company.

If you just need to add a Company to an Alumni record without one, forget the script and popp window and allow direct entry into the Company area. That will create the required related records.

If there will be more than one Company per Alumni, change the popup window layout to be based off of the Companies table. Change the script to capture the id of the person and set that in the Join table after creating a new record. Currently you have no way of showing an Alumni with more than one Company though.