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]
Tidak ada komentar:
Posting Komentar