Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Benny Thomas
  Where is Benny Thomas?
 Jeddah
 Saudi Arabia
 Benny Thomas
 Tags
Subject: What is a Form Set
Thread ID: 16249 Message ID: 16249 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Monday, October 14, 2002 10:13:03 AM         
   



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
ENDSCAN

(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


ENTIRE THREAD

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