Newbies Dougb Posted March 22, 2006 Newbies Share Posted March 22, 2006 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 Link to comment Share on other sites More sharing options...
Razumovsky Posted March 23, 2006 Share Posted March 23, 2006 Hi Doug, Look at the 'go to related records' script step. Use the 'show only related' checkbox. Get some rest! -Raz Link to comment Share on other sites More sharing options...
Breezer Posted March 23, 2006 Share Posted March 23, 2006 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] Link to comment Share on other sites More sharing options...
Newbies Dougb Posted March 23, 2006 Author Newbies Share Posted March 23, 2006 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 Link to comment Share on other sites More sharing options...
Razumovsky Posted March 23, 2006 Share Posted March 23, 2006 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 Link to comment Share on other sites More sharing options...
Newbies Dougb Posted March 23, 2006 Author Newbies Share Posted March 23, 2006 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 Link to comment Share on other sites More sharing options...
Razumovsky Posted March 23, 2006 Share Posted March 23, 2006 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 Link to comment Share on other sites More sharing options...
Newbies Dougb Posted March 23, 2006 Author Newbies Share Posted March 23, 2006 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 Link to comment Share on other sites More sharing options...
Razumovsky Posted March 23, 2006 Share Posted March 23, 2006 (edited) 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, 2006 by Guest Link to comment Share on other sites More sharing options...
Breezer Posted March 25, 2006 Share Posted March 25, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6749 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now