Herb,
Rather than periodically update table B, why don't
you create a view that combines the information from both
tables. It will be automatically updated whenever you use
it. You can run forms or print reports from the view, or
browse and edit the data.
CREATE VIEW vwAB (InvDate, Field1, Field2) +
AS SELECT B.InvDate, A.Field1, A.Field2 +
FROM tableA A, tableB B +
WHERE (A.InvDate = B.InvDate)
This will put every column of data that you include
in your field definition from Table A together with whatever
has the corresponding InvDate from Table B. (You will want
to make sure that the InvDate is unique in Table A, and also
unique in Table B to prevent a cartesian product. This
would also be necessary if you wish to 'populate the column
"InvDate" in Table -B- with the data permanently...")
Randy Peterson
----- Original Message -----
From: "Herbert Hemberger" <[EMAIL PROTECTED]>
To: "Rbase" <[EMAIL PROTECTED]>
Sent: Tuesday, November 19, 2002 9:08 AM
Subject: Can that be done?
> I have two tables in the same Db. Lets call them -A-
and -B-
> And a column in each Table called "InvDate".
> The data is only in Table -A- and I would like to
populate the column
> "InvDate" in Table -B- with the data permanently and
update it as
> necessary.
> Could that be done? And if "Yes" how?
> Thanks for any advise and help
> Herb
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
