-----Original Message-----
I want to add a section on a website I'm making suing
frontpage that will enable my customers to check the
status of their repair by typing in their repair ticket
number. How can I do this? If you want to see what I'm
talking about visit the URL below:
http://www.netbags.com/warranty.asp? mscssid=VRBB7G12FQ399HH6XWHWHHE1DRG6DGM8
Even a small application system like this involves many
design decisions. As a result, I can't give you a very
specific answer.
In a general sense, you need to create a database of
current repair jobs, including whatever identifying
information and status you feel is appropriate. Then, you
query the database (using input from form fields as
selection criteria) and display the results.
In many cases, you'll also want to build a forms-based
security subsystem. This means the Web visitor would have
to logon with an ID and password, and then view only
those repair orders that pertain to them.
Of course, if you already have an automated system that
tracks these repair orders internally, you'll probably
want to extract the status information from that source.
To get started, you could probably use the Database
Editor component to create some pages for adding,
updating, and deleting repair records, and you could the
the Database Results Wizard to search for and display
records. However, this is definitely a low-end approach.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------