Can't figure out this form sorting, filtering, searching stuff

[KR]

Can someone please help me???
Please see my information I am working with below to understand what the
heck I am talking about.

I want a form that will allow me to:
-Search for a doctor
- Display all of the doctors implant records
- be able to select a specific study for that doctor and have it
show me all of that doctors implants for that study (their are 8 studies each
record belongs to one of the 8 studies)

Here are the tables I have and the information I am working with.

Table 1: USImplants
Fields:
Cardnumber
ProductN
LotN
SerialN
Study (Aa, Bb, Cc, Dd, Ee, Ff, Gg, Hh)
Last Name (This is the Doctors Last Name)
First Name (This is the Doctors First Name)
Site Name

Table 2: USDoctors (this table has a list of all of the doctors names with
no duplicates)
Fields:
ID (Autonumber)
LastName
FirstName

Table 3: Devices (Not sure if I need this table or the US Doctors table)
ID (Autonumber)
Devices (Aa, Bb, Cc, Dd, Ee, Ff, Gg, Hh)

If someone can help me you are a genius and I appreciate it so much....my
brain is starting to hurt and I can't think anymore

 

[Tom Willett]

Is this an Excel question? If so, you need to ask in an Excel newsgroup.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage Since 1997
---------------------------
: Can someone please help me???
: Please see my information I am working with below to understand what the
: heck I am talking about.
:
: I want a form that will allow me to:
: -Search for a doctor
: - Display all of the doctors implant records
: - be able to select a specific study for that doctor and have it
: show me all of that doctors implants for that study (their are 8 studies
each
: record belongs to one of the 8 studies)
:
: Here are the tables I have and the information I am working with.
:
: Table 1: USImplants
: Fields:
: Cardnumber
: ProductN
: LotN
: SerialN
: Study (Aa, Bb, Cc, Dd, Ee, Ff, Gg, Hh)
: Last Name (This is the Doctors Last Name)
: First Name (This is the Doctors First Name)
: Site Name
:
: Table 2: USDoctors (this table has a list of all of the doctors names with
: no duplicates)
: Fields:
: ID (Autonumber)
: LastName
: FirstName
:
: Table 3: Devices (Not sure if I need this table or the US Doctors table)
: ID (Autonumber)
: Devices (Aa, Bb, Cc, Dd, Ee, Ff, Gg, Hh)
:
: If someone can help me you are a genius and I appreciate it so much....my
: brain is starting to hurt and I can't think anymore
:

 

[Ronx]

Looks more like a database question to me. The database needs to be
normalised, and the question made clearer. An Access group or forum may be
more appropriate.

--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.