Arlene, Mike et al.,
Thank you so much. I don't know how I missed the second matching column
name. Once I removed the second matching name, the form works great.
Thanks again,
James
----- Original Message -----
From: "Mike Byerley" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, July 01, 2010 1:13 PM
Subject: [RBASE-L] - Re: 2-table form with region - how do I make it work?
You are correct it will NOT work if there is more than one matching
column. In the slave table, make it a single table (editable) view and use
the "AS Alias" assignment for whichever column is unwanted in the link.
----- Original Message -----
From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, July 01, 2010 12:53 PM
Subject: [RBASE-L] - Re: 2-table form with region - how do I make it work?
I don't know if this helps - but you have not only the column cid - but
also the column todate - in both tables.
I believe that the data must agree in both columns in both tables - in
order to show in the scrolling region.
Arlene Collins
Evergreen Packaging Inc.
"James W. Kim"
<james....@kimcpa
.com> To
Sent by: [email protected] (RBASE-L Mailing
[email protected] List)
cc
06/30/2010 11:23 Subject
AM [RBASE-L] - 2-table form with
region - how do I make it work?
Please respond to
[email protected]
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.
DISCLAIMER: This electronic message together with any attachments is
confidential. If you are not the intended recipient, do not copy,
disclose or
use the contents in any way. Please also advise us by return e-mail that
you
have received the message and then please destroy. Evergreen Packaging is
not
responsible for any changes made to this message and / or any attachments
after
sending by Evergreen Packaging. We use virus scanning software but
exclude all
liability for viruses or anything similar in this email or any
attachment.
--
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.
