need help

[Guest]

need help to do the following
1.want combo box to dispaly data from two tables(one table is hospitals ,
other is doctors.) i.e. to show one list containing both hospitals and doctors

2.want to creat a search form to search in any field in a table.(search in
all filds)

 

[John Vinson]

need help to do the following
1.want combo box to dispaly data from two tables(one table is hospitals ,
other is doctors.) i.e. to show one list containing both hospitals and doctors

Base the combo bos on a UNION query. See online help for UNION, and
post back if you need help.

I'm puzzled what you would *do* with this combo box. What use will you
make of the "St. Jude's" or "Dr. K. Ravindranathan" result?

2.want to creat a search form to search in any field in a table.(search in
all filds)

You can do this... but in a properly designed database this makes no
sense. A table will typically have multiple fields of different
datatypes and different meanings. It makes no sense to search a
numeric ID field for a text value, or a text field for a date, or even
an Address field for a person's name. Could you explain why you feel
that this capability is needed?

John W. Vinson[MVP]

 

[Guest]

thanks john..
1.i am accounting patients expenses .some times i recieve invoices issued by
hospitals , and sometimes issued by doctors.i want to enter " invoice issuer"
wheather is hospital or is doctor. i have a field for this.currently is
showing my combo is showing only hospitals , doctors a have to type manually
in the same filed.

2.actually , i enter all info about patients.sometimes, i need to search for
data and get result as soon as possible.i have many fields like
A.diagnosis Category "Cardiac,cancer e.t.c.
B.Treatment:"Open heart Surgey,radiotherapy e.t.c.
B.full Diagnosis:tetrology of fallot,acute myloid leukemia e.t.c.
c.remarks:for any notes

sometimes, treatment entered for one patient is e.g.chemotherapy, but asume
patient when admitted , received also radiotherapy.in my remaks, i will
say"Patient also received radiotherapy.so , if my boss asked my which patient
recieved radiotherapy.i have give all the patients with the "treatment"
Radiotherapy plus this patient.i want so search for the word"Radiotherapy in
any of these fields.

i didnt get any benifit by reffering to "union" as am new user but trying to
learn as fast as possible.if you kindly give some details