R
Robert Cohen
Hello All,
I don't know if this is the right group or not to discuss this issue with, but I am hoping so. I have an SQL database and am trying to use frontpage as my interface. I am able to query the database fine and present the data on a webpage; however, I want a way to modify- add entries and such from the website. The question is, how do I do this within Frontpage on an interrelational database.
For a simple example. I have these three tables tblstaff, tblposition, tblstaffposition
tblstaff is just an sequence number for each staff, the staff's first and last name
tblposition is just a sequence number and the positions
tblstaffposition is just sequence number for staff and sequence number for position
If I use the following, I get results and with modifying which fields get shown, I can have the results of just the staffs' names and position
SELECT tblstaff.iseq, tblstaff.clname, tblstaff.cfname, tblposition.iseq, tblposition.cposition, tblstaffposition.iseqStaff, tblstaffposition.iseqPosition
FROM tblstaff, tblposition, tblstaffposition
WHERE tblstaffposition.iseqstaff = tblstaff.iseq
AND tblstaffposition.iseqposition = tblposition.iseq
However, I want to be able to add new staff and assign them positions within the webpage. THat is where I am stuck at. I can create a submittal page for tblstaffposition and be able to enter the sequence number for staff and position. But what I want to do is add a staff name and from a drop down list, click on position and for the webpage to add the staff member into tblstaff with a new sequence number and to add the staff name sequence number and position name sequence number into tblstaffposition
Can someone point me in the right direction.
I don't know if this is the right group or not to discuss this issue with, but I am hoping so. I have an SQL database and am trying to use frontpage as my interface. I am able to query the database fine and present the data on a webpage; however, I want a way to modify- add entries and such from the website. The question is, how do I do this within Frontpage on an interrelational database.
For a simple example. I have these three tables tblstaff, tblposition, tblstaffposition
tblstaff is just an sequence number for each staff, the staff's first and last name
tblposition is just a sequence number and the positions
tblstaffposition is just sequence number for staff and sequence number for position
If I use the following, I get results and with modifying which fields get shown, I can have the results of just the staffs' names and position
SELECT tblstaff.iseq, tblstaff.clname, tblstaff.cfname, tblposition.iseq, tblposition.cposition, tblstaffposition.iseqStaff, tblstaffposition.iseqPosition
FROM tblstaff, tblposition, tblstaffposition
WHERE tblstaffposition.iseqstaff = tblstaff.iseq
AND tblstaffposition.iseqposition = tblposition.iseq
However, I want to be able to add new staff and assign them positions within the webpage. THat is where I am stuck at. I can create a submittal page for tblstaffposition and be able to enter the sequence number for staff and position. But what I want to do is add a staff name and from a drop down list, click on position and for the webpage to add the staff member into tblstaff with a new sequence number and to add the staff name sequence number and position name sequence number into tblstaffposition
Can someone point me in the right direction.