I have a FMP7 file that has 6 separate layouts. I want to have the ability to take the data that is entered into a record in layout X and transfer the related fields(within the related tables) into layout Y.

I'm sure this is very elementary, but due to my late hours and lack of brain power, I'm not getting anywhere.

Any help would be greatly appreciated.

Thanks in advance...

Doug

Hi Doug,

Look at the 'go to related records' script step. Use the 'show only related' checkbox.

Get some rest!

-Raz

Also try "Relookup" script step.

Example from the FM help files.

Show All Records

Go to Layout ["Data Entry"]

Go to Field [Table1::Invoice Number]

Set Field [Table1::Invoice Number; Max(Table1::Invoice Number)]

Relookup Field Contents [No dialog, Table1::Customer ID]

Thanks for the replies Raz and Breezer, but still no luck. I have no idea why not, but....

I'll keep messin' with it and let you know...

Thanks again.

Doug

Doug,

Are you trying to just view the same data in a different layout, or copy the data to a completeley different record in a different layout?

-Raz

Copy the data and then enter it into a new layout. The first layout is a "preliminary info" sheet for a photographer. Then when the client wants to go ahead and use his services, I want to take the data from the preliminary info sheet and transfer it to the "contract" layout...

Does that make sense?

Thanks...

Doug

Yes and no. It does make sense, but I think there might be a better way of going about it. How about creating the preliminary data in the contract table (you are confusing the word layout with table. Layouts refer to the visual interface, where table refers to where the data is stored, or how it is normalized, if you will). When preliminary contract is approved, you could just tick a checkbox indicating that it is active.

With your design, you would have to either import the record between the tables, or manually set all the fields using a script with n set field steps, where n is the number of fields in either table. Or set a relationship between the two, define each field in Contacts as a lookup to Preliminary, and set the key (What Breezer was suggesting, I believe).

All of these involve much more work than having a status field in your contracts table.

-Raz

Thanks again Raz..

The one problem is that the client does his business in the order I described and doesn't want to change that... so I may have to do the long way around...

You're right about the layout/table thing, and I think I need to redesign the tables and relationships to make this work smoother.

Thanks again for taking the time w/ me..

Take care.

Doug

The one problem is that the client does his business in the order I described and doesn't want to change that...

That shouldn't matter. You could design it so nothing would seem to have changed from their point of view.

You could use filtered portals to only display active contracts or preliminary contracts, both of which would be in the same table. Run a search on "Filtered Portals" if you are unfamiiar with the technique -there are plenty of posts. It is pretty easy, and comes in quite handy.

Regardless, good luck!

-Raz

Edited March 23, 200619 yr by Guest

I have designed a sample file to demo how you can approach this. See Attached, it's very basic but you can add some bells and whistles once you understand the concept. Eventually, you will find portals are much easier to use. You can achieve the same result with a portal without using any scripts but scripts are better in explaining the concept.

CreateRelatedRecord.zip