Search Records

[aiman]

Hi,

need help from u guys,

i'm new with access03, i created database which contain table Patient, Case,
SurgeryDetails.
i''ve created relationship between this tables where Patient is the one-side,
Case on the many-side, & SurgeryDetails is the many-side for Case. i also
created form with subforms.

How do i created a form where i can search records for Patient, and from
there i can view the Case & SurgeryDetails for the Patient & add data by
using the form??

 

[OldGuy]

I'm pretty new myself, but try opening your form in design view and click the
Combo Box Button on the tool box bar. a wizard will open and one of the
options is "Find a Record on my Form Based on the Value I selected". Hope it
helps.

 

[aiman via AccessMonster.com]

thank's for your advise..

but what i'm trying to do is to find a record based on value i type, then it
will search the database & display it if it is available.
Let say i type Patient name, it will search for the patient & display the
data. there i can add new data Case for the same Patient.

i've read about using the macro's & parameter queries... & still try to
figure it out what i'm doing wrong..

any advise would be appreciated..
tq..

 

[AccessVandal via AccessMonster.com]

I would start by looking at data models first before jumping in. You'll also
need to understand what is Normalization. Take a look at here for Doctor,
Medical,Hospital data models.

http://www.databaseanswers.org/data_models/index.htm

Unless your database is a throw away type after use. You can ignore these.

Here is the normalization you need to read first.

http://www.datamodel.org/NormalizationRules.html