Alpha Video Training
Results 1 to 3 of 3

Thread: Filter records on one table with the value of another table

  1. #1
    Member
    Real Name
    Aaron Okievs
    Join Date
    Feb 2011
    Posts
    18

    Default Filter records on one table with the value of another table

    Hello friends,

    I have the following attached image files:

    PatientForm:
    PatientsForm.png

    medicalRecordsForm:
    medicalRecordsForm.png

    According to the forms, I have two tables: patients_info and medical_records, and these tables are connected to each forms above. The Patients Name on the medicalRecordsForm is an alltrim of columns (Title, First_Name, Last_Name) from the Patient_Info Table.

    Now, the issue here is that I want to be able to filter records on the medicalRecordsForm with the selected Patient Name on the form from the Patient_Info Table. Once the patient name is selected on the medicalRecordsForm, the form will be populated with a medical record of the selected patient, if there is one. If there isn't any record of the selected patient in the form, it will display a blank or new form to enter medical records of the patient.

    Also, on the browse at the medicalRecordsForm, the column name "Patient's Visit" will always indicate (in numeric values) the amount of visits the patient has had anytime the details of the medicalRecordsForm form is edited and saved. This area is still a puzzle to me too.

    So, Using the Patient_Info table row to filter the records on the Medical_Info table is a problem to me. I guess this is done either on the table or on the form. I don't know how to make this work.

    Any ideas?

    Thanks.

    Aaron

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Filter records on one table with the value of another table

    The Please Read Before Posting suggests that a sample database often leads to the quickest and best answers (not guesses). Pictures are nice but don't tell the whole story.

  3. #3
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,366

    Default Re: Filter records on one table with the value of another table

    Sounds like a Set is required here.
    It is a simple matter to display records from two tables if they are linked as a Set.
    Do as Stan suggests for a quick solution/answer/suggestion.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

Similar Threads

  1. Lookup with dynamic filter in child table using field from parent table
    By Fisher in forum Application Server Version 11 - Web/Browser Applications
    Replies: 4
    Last Post: 11-11-2011, 09:06 AM
  2. count records on linked table filter by a data field in the current row
    By brad.lindsay69@gmail.com in forum Application Server Version 10 - Web/Browser Applications
    Replies: 12
    Last Post: 07-29-2011, 02:15 AM
  3. Join Table-Filter Child Table Complex
    By Leah in forum Alpha Five Version 9 - Desktop Applications
    Replies: 3
    Last Post: 02-19-2009, 06:29 PM
  4. child table filter based on field in parent table
    By turbojack in forum Alpha Five Version 8
    Replies: 11
    Last Post: 03-19-2007, 08:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •