3 Replies Latest reply on Nov 29, 2012 9:06 AM by philmodjunk

    Help setting up database for new user

    WendellNeeley

      Title

      Help setting up database for new user

      Post

           Hi all.  Thanks for taking the time to help out.  I'm a newb at using Filemaker (or at least at designing databases) so please be patient if I appear a bit dense.

           I'm an orthodontist and am trying to set up a tracking database for my new patients (let's call it New Patient Exams).  I want to be able to input relevant new patient exam data, such as date of exam, whether they showed up for the appointment, etc) and have a critical input of whether or not the patient scheduled their start appointment (the appointment where we put the braces on).  If the answer is "yes" to this, I would like the database to open another database (New Patient Starts) where I can put in releant information about the start (start date, fee, insurance amount, treatment type, etc.) and to populate the appropriate fields with data that might be duplicated (name, DOB, etc.).  I don't want an entry to exist in New Patient Starts for patients that did not answer no to the critical question of whether or not they scheduled to start.

           Is this possible in Filemaker, or am I being too ambitious?

        • 1. Re: Help setting up database for new user
          Sorbsbuster

               I would suggest you are over-complicating.  You can easily keep all of the information in one table.  (And certainly not another database.)

               You can have a short-order layout that collects all the basic info required up to the point of their starting appointment.  If they then get tagged as 'Started' you can add the more detailed information on another layout, and even related records of subsequent appointments, for example.  If ever you find yourself saying something like 'I enter a lot of duplicated data', or 'I have a table that is almost exactly the same as another table' then alarm bells should sound that the design should probably be reviewed.

          • 2. Re: Help setting up database for new user
            WendellNeeley

                 Okay, so the problem I'm running into with one table occurrence is the following:  I keep track of two main statistics that are related, New patient exams and New patient starts.  All new patients have an exam, so it's easy to do statistics on the information such as whether or not they showed up for their exam, how old they were at the time of the exam, etc..  I run into issues with the New patient starts, however, if I keep it all in one table occurrence.  Not every patient that has a New patient exam starts, so I have a lot of records with empty data.  That is problematic for getting back averages on important stats such as Fee charged, Discount given, etc.  Any ideas on how to improve this?  Is there a calculation that I can do to rid myself of all the blank fields without them being included in the calculation, or should this information be kept in separate table occurrences?

            • 3. Re: Help setting up database for new user
              philmodjunk

                   A table occurrence and a table are not the same thing. Tables are created on Manage | Database | Tables. Table occurrences are the boxes created in Manage | Database | Relationships.