James, Actually you have TWO common columns: cID todate both of the values much match in the slave table for them to be displayed.
Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: jamesCPA <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, June 30, 2010 8:28:03 PM Subject: [RBASE-L] - Re: 2-table form with region - how do I make it work? Thank you for the suggestions. I will test a little bit more. Funny thing is that the form used to work OK but suddenly fails now. James ----- Original Message ----- >From: Victor Timmons >To: RBASE-L Mailing List >Sent: Wednesday, June 30, 2010 12:27 PM >Subject: [RBASE-L] - Re: 2-table form with region - how do I make it work? > > >This may sound to simple but make sure that you have assigned the scrolling >region to the right table. It will default to the main table but still let >you put controls that are assigned to the other table in it, the result the >scrolling region does not show anything. > > >Victor Timmons >Tiz's Door Sales, Inc >Visit us at www.tizdoors.com > PPlease consider the environment before printing this e-mail > > > ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen >Sent: Wednesday, June 30, 2010 8:36 AM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Re: 2-table form with region - how do I make it work? > > >James, > >I didn't fully scan down your list but make sure that you don't >have any COMMON columns. > >Jan > > >-----Original Message----- >>From: "James W. Kim" <[email protected]> >>To: [email protected] (RBASE-L Mailing List) >>Date: Wed, 30 Jun 2010 11:23:05 -0400 >>Subject: [RBASE-L] - 2-table form with region - how do I make it work? >> >> >>Hi, >> >>I have some forms that have main table and slave table where the slave >>table data are shown on scrolling region. These two tables are linked >>by >>primary key and foreign key references. >> >>Some forms work and some forms do not work. That is some forms >>correctly >>pull editable rows from the slave table whereas some forms just show the >>main table data and leaves the scrolling regions blank. On these >>non-working forms, I can still enter the scrolling region and enter new >>data to the slave table. >> >>Can someone tell me what I might need to watch out for when creating >>these >>2-table forms? >> >>Any suggestions would be appreciated, >> >>James Kim >> >>----------------------------------------------------------------------------------------- >> >> >>For example, one of the non-working form consists of two tables as >follows: >> >>MAIN TABLE >> >> Table: billCust No Lock(s) >> Descr: Billing Customer Table >> >> No. Column Name Attributes >> --- ------------------ >>------------------------------------------------------ >> 1 ID Type : TEXT >>10 >> >> Index : >>SINGLE-COLUMN >> >> 2 cID Type : TEXT >>6 >> >> Consrnt: PRIMARY KEY >>REFERENCED >> >> Index : >>SINGLE-COLUMN >> >> 3 cstat Type : TEXT >>1 >> >> Index : >>SINGLE-COLUMN >> >> Default: >>R >> >> Comment: R-egular billing, S-pecial >>billing, >> >> N-ot >>active >> >> 4 cLn Type : TEXT >>20 >> >> Index : >>SINGLE-COLUMN >> >> 5 cFn Type : TEXT >>20 >> >> Index : >>SINGLE-COLUMN >> >> 6 cPF Type : TEXT >>10 >> >> No. Column Name Attributes >> --- ------------------ >>------------------------------------------------------ >> 7 cCompany Type : TEXT >>100 >> >> Index : >>SINGLE-COLUMN >> >> 8 cRef Type : TEXT >>100 >> >> Index : >>SINGLE-COLUMN >> >> Comment: reference >>line >> >> 9 cAdd1 Type : TEXT >>50 >> >> Index : >>SINGLE-COLUMN >> >> 10 cAdd2 Type : TEXT >>50 >> >> Index : >>SINGLE-COLUMN >> >> 11 cPhone Type : TEXT >>20 >> >> Index : >>SINGLE-COLUMN >> >> 12 cFax Type : TEXT >>20 >> >> Index : >>SINGLE-COLUMN >> >> 13 email Type : TEXT >>100 >> >> Index : >>SINGLE-COLUMN >> >> 14 cWeb Type : TEXT >>50 >> >> Index : >>SINGLE-COLUMN >> >> No. Column Name Attributes >> --- ------------------ >>------------------------------------------------------ >> 15 cNote Type : >>NOTE >> >> Comment: >>Note >> >> 16 ccType Type : TEXT >>2 >> >> Consrnt: FOREIGN KEY REFERENCES >>billPType >> >> 17 ccNum Type : TEXT >>60 >> >> 18 ccExpire Type : >>DATE >> >> 19 ccOwnerName Type : TEXT >>60 >> >> 20 doclocation Type : TEXT >>150 >> >> 21 InsuranceToDate Type : >>DATE >> >> 22 b1 Type : >>CURRENCY >> >> 23 b2 Type : >>CURRENCY >> >> 24 b3 Type : >>CURRENCY >> >> 25 b4 Type : >>CURRENCY >> >> 26 b5 Type : >>CURRENCY >> >> 27 b6 Type : >>CURRENCY >> >> 28 b7 Type : >>CURRENCY >> >> No. Column Name Attributes >> --- ------------------ >>------------------------------------------------------ >> 29 b8 Type : >>CURRENCY >> >> 30 b9 Type : >>CURRENCY >> >> 31 b10 Type : >>CURRENCY >> >> 32 b11 Type : >>CURRENCY >> >> 33 b12 Type : >>CURRENCY >> >> 34 bx1 Type : TEXT >>8 >> >> 35 bx2 Type : TEXT >>8 >> >> 36 bx3 Type : TEXT >>8 >> >> 37 bx4 Type : TEXT >>8 >> >> 38 bx5 Type : TEXT >>8 >> >> 39 bx6 Type : TEXT >>8 >> >> 40 bx7 Type : TEXT >>8 >> >> 41 bx8 Type : TEXT >>8 >> >> 42 bx9 Type : TEXT >>8 >> >> 43 bx10 Type : TEXT >>8 >> >> 44 bx11 Type : TEXT >>8 >> >> No. Column Name Attributes >> --- ------------------ >>------------------------------------------------------ >> 45 bx12 Type : TEXT >>8 >> >> 46 initdate Type : >>DATE >> >> 47 todate Type : >>DATE >> >> 48 retax Type : TEXT >>200 >> >> 49 cc Type : TEXT >>200 >> >> 50 sd Type : TEXT >>200 >> >> Current number of rows: 36 >> >>SLAVE TABLE >> >> Table: billLease No Lock(s) >> Descr: Tenant Lease Schedule >> >> No. Column Name Attributes >> --- ------------------ >>------------------------------------------------------ >> 1 cid Type : TEXT >>6 >> >> Consrnt: FOREIGN KEY REFERENCES >>billCust >> >> Index : >>SINGLE-COLUMN >> >> 2 fromdate Type : >>DATE >> >> Index : >>SINGLE-COLUMN >> >> 3 todate Type : >>DATE >> >> Index : >>SINGLE-COLUMN >> >> 4 amt Type : >>CURRENCY >> >> 5 description Type : TEXT >>100 >> >> Index : >>SINGLE-COLUMN >> >> Current number of rows: 83 >> >> >>~~ >>This message has been scanned for viruses and dangerous content >>by MailScanner, and is believed to be clean. ~~ This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~~ This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
