Correct. Remove the DB-Edit on the linking column on the slave table and you should see everything
-----Original Message----- From: "James W. Kim" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 30 Jun 2010 11:50:35 -0400 Subject: [RBASE-L] - Re: 2-table form with region - how do I make it work? Jan, I have only one common column that is the primary key referenced in the main table and foreign key referenced in the slave table. I am guessing that the common column is what links the two tables. James ----- Original Message ----- From: jan johansen To: RBASE-L Mailing List Sent: Wednesday, June 30, 2010 11:36 AM 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.
