I'm still not quite there: 1) How do I clear all the fields to input the next record if I use the Custom EEP below?
2) I've added a scrolling region to the second table. How do I save the first record and tell it that I want to add a second one? 3) How do I leave the scrolling region, save everything in it and go on to the third table? thanks, Lin On Wed, 13 Feb 2008 05:43:04 -0800, "Lin MacDonald" <[EMAIL PROTECTED]> said: > Thanks Razzak! > > On Wed, 13 Feb 2008 08:31:07 -0500, "A. Razzak Memon" <[EMAIL PROTECTED]> > said: > > At 08:16 AM 2/13/2008, Lin MacDonald wrote: > > > > >I have designed a form that uses 3 tables. The first section is the > > >Supplier > > >Table which has a one to many relationship with the other two. The second > > >is > > >the Contacts table (which will eventually be tiers in a region) and the > > >third > > >is the Inventory table (what the Supplier has -- also will > > >eventually be tiers > > >in a region). > > > > > >The form is not saving properly so I think I have missed something. > > >Do I need > > >to do a save and continue after each section? At the moment, if I use my > > >"Save & New" button at the bottom of the form, it saves the last section > > >and > > >clears that one only, rather than the whole form. > > > > Lin, > > > > Basically, your "Save & New" button is not associated with any table. It > > simply > > saves the changes of "last focused" section/region/table of your > > multi-table > > form. > > > > To achieve the expected results, you may use the "DB Navigator" for each > > table, > > or you may update "Save & New" button properties with the following > > Custom EEP: > > > > PROPERTY TABLE firsttablename 'POST' > > PROPERTY TABLE secondtablename 'POST' > > PROPERTY TABLE thirdtablename 'POST' > > RETURN > > > > For complete details, TABLE properties, and more ... refer to R:Docs 7.6. > > > > Very Best R:egards, > > > > Razzak. > > > > > >
