Herb, What is the relationship between table A and table B? Is it a one to many relationship? Can you give us some more info? For example; does table A hold the summary data for the invoice where table B holds the various detail lines?
As mentioned previously, it can be done. Myron Finegold Port Authority of NY&NJ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of randyp Sent: Tuesday, November 19, 2002 11:37 AM To: [EMAIL PROTECTED] Subject: Re: Can that be done? 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/ ================================================ 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/
