ACCESS FEED: RE: [MS_AccessPros] Re: Help with relationships

Hi John,

as you can see from the code, some of what Joe used is based on stuff I helped him with several years ago for a different project ... he never understood it though. Now he is building a similar database -- he needs to start at the beginning with tables and relationships -- forget there are forms and code. Thanks for helping him ;) I am studying so much (mobile technologies) that I can only answer quick questions

Warm Regards,
Crystal

*
(: have an awesome day :)
*

--- On Tue, 5/31/11, John Viescas <john@viescas.com> wrote:

> From: John Viescas
> Joe-
>
> The relationships that you have already looked fine to
> me. Any relationship should put the table with the
> Primary Key (key symbol) on the "left" and the table with
> the Foreign Key on the "right." You need to finish all
> the relationships from the L_ tables. You have one
> relationship between L_Results and Results that probably
> should have Referential Integrity defined.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com]
> On Behalf Of Joe HErnandez
> Sent: Tuesday, May 31, 2011 10:08 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Help with relationships
>
> Yes I will need all the assistance and suggestions you can
> offer. Right about now I need to know how to relate them to
> each other. This is the area where I am lost at. Can you
> please tell me where to place each table (right or Left of
> the main form) and which ones get attached to which ones.
> Would you link them for me?
>
> Joe
>
>
> ________________________________
> From: John Viescas <john@viescas.com>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, May 31, 2011 3:00 PM
> Subject: RE: [MS_AccessPros] Re: Help with relationships
>
>
>
> Joe-
>
> It landed in the main Files folder. You should have
> clicked 2_AssistanceNeeded, and then clicked the Add File
> link.
>
> It looks pretty good now. I see you've also started
> to build some forms. Let us know if you need
> additional help.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> P.S. You should delete your file to free up space in the
> amount alloted to the group.
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com]
> On Behalf Of Joe HErnandez
> Sent: Tuesday, May 31, 2011 8:26 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Help with relationships
>
> John;
> Where exactly do I find this folder?
> I've tried to locate it but can't?
>
> Joe
>
> P.S. I don't know where the db landed but I sent it in a
> while ago.
>
> ________________________________
> From: John Viescas <john@viescas.com>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, May 31, 2011 11:58 AM
> Subject: RE: [MS_AccessPros] Re: Help with relationships
>
> Joe-
>
> You could compact / zip, and post it to the group
> Assistance Needed folder.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com]
> On Behalf Of Joe HErnandez
> Sent: Tuesday, May 31, 2011 5:48 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Help with relationships
>
> John;
>
> I made the changes you suggested to the db.
> Do you want me to re-send it to you so that you can look it
> over?
>
> Joe
>
> ________________________________
> From: John Viescas <john@viescas.com>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, May 31, 2011 12:58 AM
> Subject: RE: [MS_AccessPros] Re: Help with relationships
>
> Joe-
>
> Wow! Freddy & Soraya must be pretty special
> people to have fields named after them in the
> database. <s> What happens if Soraya finds
> a better job and moves on? You'll have to redesign
> your table - and that's not a good idea. I have no
> idea how you plan to enforce security, but a Users table
> should normally look like:
>
> tblUsers:
> UserID (PKey)
> UserName
> UserPswd
> UserAuth
>
> Then you put rows in for Soraya and Freddie and set their
> authorization level. If another person comes on board,
> you just add a row. If someone leaves, you delete the
> row. No changes to the design necessary.
>
> As for tracking patients and results, it might look
> something like:
>
> tblPatients:
> PatientID:
> PatientName
> .. other relevant fields such as address, phone number,
> referring doctor, etc.
>
> tblPatientAppointments:
> AppointmentID
> PatientID
> AppointmentDate
> ... etc.
>
> tblPatientAppointmentTests:
> TestID
> AppointmentID
> TestType
> TestResult
>
> If a particular test can have more than one result, then
> instead of putting TestResult in that table, you'll need:
>
> tblPatientApptTestResults:
> ResultID
> TestID
> Result
>
> The database will have one row for each patient, one row
> for each appointment, one row for each test performed during
> an appointment, and one row for each result for each
> test. To track "next" appointment, you might need a
> FollowUpDate in tblPatientAppointments, but you'll create a
> new row in tblPatientAppointments for the follow-up.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com]
> On Behalf Of Joe HErnandez
> Sent: Tuesday, May 31, 2011 12:57 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Help with relationships
>
> John; thanks for getting back to me.
>
> The purpose of this db is to track:
> ·
>    Patient/clients'
> visits (dates)
> · When and
> if they returned for results ,after each test (dates)
> ·    When is
> their follow- up appts .
> Please keep in mind that these patients (most of them)
> will
> return multiple times for re- testing and after each test
> they in turn will
> return for results. Hence, the
> repetition.
>
> The two people who will be doing the tests
> (testers)   are Soraya and Freddie.
>
> ________________________________
> From: johnvmvp <john@viescas.com>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Monday, May 30, 2011 11:43 AM
> Subject: [MS_AccessPros] Re: Help with relationships
>
> Joe-
>
> I have your database, but the purpose of the database is
> not clear.
>
> You have a bad problem with both the Tests and Results
> tables. In the Tests tables, fields like TestDt1,
> TestDt2 and 2ndTestAppt_DT and 3rdTestAppt_DT are repeating
> groups. Ditto Rslt1, Rslt2, Rslt3, etc. in Results.
>
> The fields in L_AccessLevel make no sense. What are
> the Soraya and Freddie fields?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> --- In MS_Access_Professionals@yahoogroups.com,
> "JoeH" <jomahe0143@...> wrote:
> >
> > I am trying to build a database for my daughter. So
> far I have identified the tables and built some of the forms
> I feel I need.
> > I would like someone to help me connect the
> relationships and if at all possible provide any feedback
> deemed useful.
> >
> > If you need to see what I have done up to this point,
> please let me know how to attach the file.
> >
> > In advance I thank you
> > sincerely
> > Joe Hernandez
> >
> > P.S. I am using Access 2010 and my OS is Win 7.
> >