Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Pete Sass
 To: Paul Brown
 Paul Brown
Subject: RE: What is a Form Set
Thread ID: 16249 Message ID: 16267 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Monday, October 14, 2002 10:15:56 PM         

> Benny
> Don't be using formsets for a start :)
> Try...
> One form with a pageframe with 4 tabs. Just disable the pages that are not active.
> Create 4 form classes. Create each one with CREATEOBJECT(). Instead of releasing each form make them invisiible so you are not creating them each time (move the code in the Load to a new method).
> Paul
> >
> > I have a situation where there user scan through Table_1 and for each record in Table_1, adds one new record each to four tables (Table A, B, C & D). Data for Table A,B,C and D are taken from Table_1 and modified a little bit by the users (if necessary). What I am currently doing is give four Forms (Form A, B, C & D) with data for modification. User update data in Form A, save it, then close, then open Form B, save it, close it, then Form C, and Form D. And this process will be repeated till you reach end of Table_1.
> >
> > Code as follows (simply)
> >
> > Select Table_1
> > SCAN
> > Do form A
> > Release form A
> > Do form B
> > Release form B
> > Do form C
> > Release form C
> > Do form D
> > Release form D
> >
> > (I release and close form because in the Load event of each form certain code is run to prepare data for that form from Table_1 record)
> >
> > This is working ok, but the problem is it is taking time because for every record in Table_1, it has to open and close four forms (In case of some records, Form A or Form B not needed as no data to be written to Table A or B). Is there a better way to work around this. Can I use Form Sets for this purpose? Or one Form with four Page Frames?? Keep in mind that the order in which user update data should be from A to D always. He cannot go to D, then to B and then to A etc.
> >
> > Suggestions from experts are welcome.
> >
> > Thanks in advance.
> >
> > Benny Thomas

Hi from Pete,

Please read the article section in Foxite about formsets... then make up your own mind if formsets
are applicable to what you are trying to accomplish. I use formsets all the time... contrary to
what most may advise !

Let me know your feedback on this for your application ???

Pete from the Great White North ! (Only in Canada, ay...) Over and Out ...


What is a Form Set Posted by Benny Thomas @ 10/14/2002 10:13:03 AM
RE: What is a Form Set Posted by Paul Brown @ 10/14/2002 10:31:07 AM
RE: What is a Form Set Posted by Pete Sass @ 10/14/2002 10:15:56 PM