This is a multi-part message in MIME format.
------=_NextPart_000_0013_01C3CFAA.50180FD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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 =3D tblstaff.iseq=20
AND tblstaffposition.iseqposition =3D 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.
--=20
Robert Cohen
A legend in his own mind
--
------=_NextPart_000_0013_01C3CFAA.50180FD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello All,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> I don't know if this =
is the=20
right group or not to discuss this issue with, but I am hoping so. =
I have=20
an SQL database and am trying to use frontpage as my interface. I =
am able=20
to query the database fine and present the data on a webpage; however, I =
want a=20
way to modify- add entries and such from the website. The question =
is, how=20
do I do this within Frontpage on an interrelational =
database.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>For a simple example. I have =
these three=20
tables tblstaff, tblposition, tblstaffposition</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>tblstaff is just an sequence number for =
each staff,=20
the staff's first and last name</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>tblposition is just a sequence number =
and the=20
positions</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>tblstaffposition is just sequence =
number for staff=20
and sequence number for position</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>If I use the following, I get results =
and with=20
modifying which fields get shown, I can have the results of just the =
staffs'=20
names and position</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>SELECT tblstaff.iseq, tblstaff.clname,=20
tblstaff.cfname, tblposition.iseq, tblposition.cposition,=20
tblstaffposition.iseqStaff, tblstaffposition.iseqPosition<BR>FROM =
tblstaff,=20
tblposition, tblstaffposition<BR>WHERE tblstaffposition.iseqstaff =3D=20
tblstaff.iseq <BR>AND tblstaffposition.iseqposition =3D=20
tblposition.iseq</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>However, I want to be able to add new =
staff and=20
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=20
enter the sequence number for staff and position. But what I want =
to do is=20
add a staff name and from a drop down list, click on position and for =
the=20
webpage to add the staff member into tblstaff with a new sequence number =
and to=20
add the staff name sequence number and position name sequence number =
into=20
tblstaffposition</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Can someone point me in the right=20
direction.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> </DIV>
<DIV><BR>-- <BR>Robert Cohen<BR>A legend in his own=20
mind<BR>--<BR></DIV></FONT></BODY></HTML>
------=_NextPart_000_0013_01C3CFAA.50180FD0--