If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Search Records
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?? |
#2
|
|||
|
|||
Search Records
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" wrote: 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?? |
#3
|
|||
|
|||
Search Records
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.. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200801/1 |
#4
|
|||
|
|||
Search Records
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 aiman wrote: 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?? -- Please Rate the posting if helps you Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200801/1 |
Thread Tools | |
Display Modes | |
|
|