Lantica User Forum - Exporting data from subform & compiling

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Exporting data from subform & compiling

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Exporting data from subform & compiling (Read 567 times)

Blair Wettlaufer Junior Member Members Offline No personal text Posts: 98 Location: Hamilton, ON Joined: Jun 4^th, 2005	Exporting data from subform & compiling Aug 3^rd, 2006 at 7:04pm	Print Post
	Hi all, I'm looking to replace a subform on my database with a single field. I had built a subform for note lines in my contact management program, and it's not necessary when a single field for all notes will do. How can I easily extract all my data and compile my subform notes into 1 record? When I export my subform data it comes out as "0001","note1" "0001","note2" When I really want: "0001","note1","note2" Help? Blair

	Coesper erat: tunc lubriciles altravia circum&&Urgebant gyros gimbiculosque tophi:&&Moestenui visae borogovides ire meatu:&&Et profugi gemitus exgrabuere rathae
	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Exporting data from subform & compiling Reply #1 - Aug 3^rd, 2006 at 7:11pm	Print Post
	Hello Blair, You will want to run a Mass Update, on the parent form, that loops through the subform, grabs all the data, strings it together, and places it in the destination element. Have a look at the following two commands in the programming guide. @FormResultSetTotal() @FormFieldValue() Using those two you can loop through all the subrecords for one parent and get the data you need. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›