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
