Thank you Pete.
It is now clear and fixed.
>
What I can't get clear is, what you will (are able to
/ are allow to)
do. It seems that you don't want to do any data
shuffling to put the
data right? You just want to add one field to the
Patients table? And
you don't have a code number for the drugs, just a
tablename. Do you
appreciate that you would build table3 with SQL
commands, not by typing?
You see, I don't understand why you have this problem.
I can see that,
historically, the database was designed badly, and
needs putting right.
But you seem to be saying that you cannot (are not
allowed to?) put it
right. Or is it just that you don't want to?
>
You see the point of creating a third table totally
escaped my mind - and its a fact of life that people
have different IQs ;)
At first I didnt know that it was intended as a
"look-up" table etc.. But now its crystal clear..
obviously its the logical and correct way of doing it.
Thank you for your contribution.
Best regards
David
___________________________________________________________
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail
http://uk.messenger.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/CefplB/TM
--------------------------------------------------------------------~->
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
