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.
