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
