Patients-physician-querry
relational database with 2 tables, physicians and Clients,
In the Client DB, there is a number that implies the physician,
I can easily make a form where you put in the physicians number,
but..
If I want the dropdown box to show the name of the physician I have to
base it on the other table. (the physician table),
Now when I choose a different last name it will update the wrong
table. (the physician table),
In the client form, is it possible to choose the physician based on
his name rather than the number?
thanks,
crzzy1 4 1987 co*****@hotmail.com (CJ) wrote in
news:10**************************@posting.google.c om: Patients-physician-querry relational database with 2 tables, physicians and Clients, In the Client DB, there is a number that implies the physician,
I can easily make a form where you put in the physicians number, but.. If I want the dropdown box to show the name of the physician I have to base it on the other table. (the physician table),
Now when I choose a different last name it will update the wrong table. (the physician table),
In the client form, is it possible to choose the physician based on his name rather than the number?
thanks, crzzy1
Yes, this can easily be done with the Combobox wizard, when you
create a new combobox.
Just make the first column the number, and the second (and third)
last name (and firstname). You can make the width of the number
column 0, so it doesn't show in the combobox, but stores it in the
table..
..
Bob Q co*****@hotmail.com (CJ) wrote in
news:10**************************@posting.google.c om: Patients-physician-querry relational database with 2 tables, physicians and Clients, In the Client DB, there is a number that implies the physician,
I can easily make a form where you put in the physicians number, but.. If I want the dropdown box to show the name of the physician I have to base it on the other table. (the physician table),
Now when I choose a different last name it will update the wrong table. (the physician table),
In the client form, is it possible to choose the physician based on his name rather than the number?
thanks, crzzy1
Yes, this can easily be done with the Combobox wizard, when you
create a new combobox.
Just make the first column the number, and the second (and third)
last name (and firstname). You can make the width of the number
column 0, so it doesn't show in the combobox, but stores it in the
table..
..
Bob Q
Bob Quintal <bq******@generation.net> wrote in message news:<35******************************@news.terane ws.com>... co*****@hotmail.com (CJ) wrote in news:10**************************@posting.google.c om:
Patients-physician-querry relational database with 2 tables, physicians and Clients, In the Client DB, there is a number that implies the physician,
I can easily make a form where you put in the physicians number, but.. If I want the dropdown box to show the name of the physician I have to base it on the other table. (the physician table),
Now when I choose a different last name it will update the wrong table. (the physician table),
In the client form, is it possible to choose the physician based on his name rather than the number?
thanks, crzzy1 Yes, this can easily be done with the Combobox wizard, when you create a new combobox.
Just make the first column the number, and the second (and third) last name (and firstname). You can make the width of the number column 0, so it doesn't show in the combobox, but stores it in the table..
. Bob Q
Hmm that is good,
When I base it on my querry,
I get many instances of the same doctor's name in the dropbox, (one
for each patient)
I need to base the physicianID on the "patient table" (the foreigh
key) (that is the field I want the form to update)
I need to base the physician name on the "physician table".
When I do base both on the physician table, I can get a good listing
of non-duplicated last names, but it won't let me update the form as
it thinks I am trying to change the physician's name in that table.
any more ideas? co*****@hotmail.com (CJ) wrote in
news:10**************************@posting.google.c om: Bob Quintal <bq******@generation.net> wrote in message news:<35******************************@news.terane ws.com>... co*****@hotmail.com (CJ) wrote in news:10**************************@posting.google.c om:
> Patients-physician-querry > relational database with 2 tables, physicians and Clients, > In the Client DB, there is a number that implies the > physician, > > I can easily make a form where you put in the physicians > number, but.. > If I want the dropdown box to show the name of the > physician I have to base it on the other table. (the > physician table), > > Now when I choose a different last name it will update the > wrong table. (the physician table), > > In the client form, is it possible to choose the physician > based on his name rather than the number? > > thanks, > crzzy1 > Yes, this can easily be done with the Combobox wizard, when you create a new combobox.
Just make the first column the number, and the second (and third) last name (and firstname). You can make the width of the number column 0, so it doesn't show in the combobox, but stores it in the table..
. Bob Q
Hmm that is good, When I base it on my querry, I get many instances of the same doctor's name in the dropbox, (one for each patient) I need to base the physicianID on the "patient table" (the foreigh key) (that is the field I want the form to update) I need to base the physician name on the "physician table". When I do base both on the physician table, I can get a good listing of non-duplicated last names, but it won't let me update the form as it thinks I am trying to change the physician's name in that table. any more ideas?
The combobox RowSource must be based on the physicians table. The
combobox ControlSource must point to the physicianID in the the
Clients table.
Then everything will work as you wish.
Bob Q. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mamun |
last post by:
Hi All,
I have the following case.
I am trying to update a table based on the value of dropdown box and
checkbox.
Here is what I have in page1.asp
<table>
|
by: Nick Calladine |
last post by:
Learning : Loop to list all dropdown box values on a form
Can some one point me in the right direction :
I have a form which I want to loop through
I basically want to get all the selected...
|
by: Charles |
last post by:
I am trying to add the ability for a user to change the order in which
the elements are listed in a dropdown list box. Before I added the
ListID field the dropdown list box order was controlled...
|
by: CJ |
last post by:
Patients-physician-querry
relational database with 2 tables, physicians and Clients,
In the Client DB, there is a number that implies the physician,
I can easily make a form where you put in the...
|
by: Monty |
last post by:
I use a SELECT dropdown as the nav interface for jumping to a chosen
page number. When I setup up the SELECT element on the page, I want to
show the user the current page number they are on, so, I...
|
by: Cagey |
last post by:
What I'm trying for: If this selection or if click on selection
(highlighted line choice/
which ever selection change) w/in query's combo dropdown list box (on
Switchboard),
then Open in...
|
by: Greg Scharlemann |
last post by:
I'm trying to setup a dyamic dropdown list that displays a number of
text fields based on the selected number in the dropdown. The problem
I am running into is capturing the data already entered...
|
by: zion4ever |
last post by:
Hello good people,
Please bear with me as this is my first post and I am relative new to ASP. I do have VB6 experience. I have a form which enables users within our company to do an intranet...
|
by: ghjk |
last post by:
I have a drop down box and the test box for the search field. In there I user only dropdown box to search values from the DB. But now I want to pass text box value with dropdownbox value. How can I...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |