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.
>
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar