In addition to what Razzak said, remember that RBase will automatically link on columns that have the same name. So if you have "common column names" in table 3 other than the 2 that you want to link, you will have an issue. How you fix that is to create a one-table view (to keep it editable) and rename the other common columns that you do NOT want to link by. Done this many, many times!
For example, if table 2 & 3 have 3 common columns (link1, link2, link3) and you want to link table3 to table2 based only on the columns link1 & link2, you would create a view like this, and have the VIEW as the "table" in the form: create view vTable3 (link1, link2, newcolname) as select link1, link2, link3 from table3 Karen -----Original Message----- From: Michael J. Sinclair <[email protected]> To: karentellef <[email protected]> Sent: Wed, Nov 25, 2015 6:21 pm Subject: [RBASE-L] - Re: Multi table form thank you!!! From: A. Razzak Memon <[email protected]> To: [email protected] Sent: Wednesday, November 25, 2015 7:17 PM Subject: [RBASE-L] - Re: Multi table form At 07:05 PM 11/25/2015, Michael J. Sinclair wrote: >Hi All >I want to look at 4 related tables in 1 form. >Table 1 = patinfo (patient information) >table 2 = baldue (balance due) >table 3 = oldtrans (archived transactions) >table 4 - olddets (archived details for each old transaction) > >I want display a single line for table 1 based on the column >patnumbr (patient number) >I want to display every line in table 2 that has the same patient number >I want to be able to click/select a row in table 2 that determines >which rows show up >in table 3 (matched by 2 columns, patnumbr and td_o_s_ (patient >number and date of service) >I want the same 2 columns to determine which rows are displayed in table 4. > >How do I indicate to the form which 2 rows link 1 table to the next? Once all Master and Slave tables are associated with the form, make sure to update the Table Relations to "Many-To-Many". The default is always "One-to-Many". Here's how ... Form Designer > Form Properties > Table Relations ... To understand this concept, take a close look at the "SalesTransactions" form included with RRBYW18 sample application bundled with RBG95_32 and RBG95_64 for Windows. This particular form include 5 tables. Form Name: SalesTransactions Master Table: Customer Slave Tables: InvoiceHeader, InvoiceDetail, Employee, and Contact Have fun! Very Best R:egards, Razzak
