H
Harddrive747
I got another problem. I'm creating and update page based on a few tables.
My main table is a contact table that has name, phone, position and other
information. The information like the position is a number field. I link
this to a table called position for the name of the position. This way, I
update that information in one place and everywhere it is used threw out the
web site, will have the same change.
So on the update form, I am able to select the record that I want to update
and put text fields and to specifiy default values from the orginial query.
Now what I would like to do and not totally sure how to do it is this. I
would like to query the position table for it's information so that if the
position name needs to be change, the user selects it from the drop down menu
and then the corresponding ID number from the position table will be updated
in the contact table. However, I'm unable to put a database query inside a
database query. So do I have to create a manual selection box? I would
rather not create a manual drop down box because that would require updating
it everytime a change was made to the position table. If so, how do I set
the default value from the orginal query?
Then how do I update the database with the corresponding number of the
position table?
So the real question is how do I create an SQL statement so that I can have
a drop down box? Then to set the value to what is presented in the orignial
query?
Any questions let me know
My main table is a contact table that has name, phone, position and other
information. The information like the position is a number field. I link
this to a table called position for the name of the position. This way, I
update that information in one place and everywhere it is used threw out the
web site, will have the same change.
So on the update form, I am able to select the record that I want to update
and put text fields and to specifiy default values from the orginial query.
Now what I would like to do and not totally sure how to do it is this. I
would like to query the position table for it's information so that if the
position name needs to be change, the user selects it from the drop down menu
and then the corresponding ID number from the position table will be updated
in the contact table. However, I'm unable to put a database query inside a
database query. So do I have to create a manual selection box? I would
rather not create a manual drop down box because that would require updating
it everytime a change was made to the position table. If so, how do I set
the default value from the orginal query?
Then how do I update the database with the corresponding number of the
position table?
So the real question is how do I create an SQL statement so that I can have
a drop down box? Then to set the value to what is presented in the orignial
query?
Any questions let me know