Normal Topic [Solved] Take data from sub form to main form.... (Read 644 times)
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
[Solved] Take data from sub form to main form....
Feb 4th, 2008 at 11:37pm
Print Post Print Post  
I am wanting to know how to take data from a sub form and our it in the main form change the data then put it back change into the sub form, can anyone point me in the right direction.

Either in the forms or inside sesame.

Thanks for all your wonderful help
« Last Edit: Feb 8th, 2008 at 9:46pm by Hammer »  
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Take data from sub form to main form....
Reply #1 - Feb 5th, 2008 at 3:17am
Print Post Print Post  
[quote author=drastixnz link=1202168224/0#0 date=1202168224]I am wanting to know how to take data from a sub form and our it in the main form change the data then put it back change into the sub form, can anyone point me in the right direction.[/quote]
Your sentence composition is pretty choppy, but it sounds like you should take a look at FormFieldValue() and the XResultSet family of commands.

You may also want to look at page 1 of the May 2007 issue of Inside Sesame.
  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Take data from sub form to main form....
Reply #2 - Feb 5th, 2008 at 5:51am
Print Post Print Post  
And based on what changes you want to make, you may also find XPost useful with @FormFieldValue.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Take data from sub form to main form....
Reply #3 - Feb 5th, 2008 at 2:01pm
Print Post Print Post  
Bob_Hansen wrote on Feb 5th, 2008 at 5:51am:
And based on what changes you want to make, you may also find XPost useful with @FormFieldValue. 



If you are using 2.X, Use the XResultSet Family of commands instead of XPost.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
drastixnz
Full Member
***
Offline


A Newbie....

Posts: 146
Location: New Zealand
Joined: Nov 29th, 2006
Re: Take data from sub form to main form....
Reply #4 - Feb 8th, 2008 at 9:35pm
Print Post Print Post  
Thanks Carl, i read may 2007 inside sesame and perfect just what i wanted.
  
Back to top
IP Logged