Hi AllI 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? Mike
