It seems that you're actually hoping for the visitor to
enter some kind of order, with items chosen from your
5,000 items.
Unless you're pretty good at programming, this is going to
be very difficult. Instead, you should probably
investigate so-called "shopping cart" systems.
If your ISP already provides one of these, you're good to
go. Just look around the host's support pages for
instructions. Otherwise, there are hundreds (perhaps
thousands) to choose from. You can find a few of them
listed at:
http://www.interlacken.com/winnt/res/resource.aspx?
respage=devcomp#commerce
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
-----Original Message-----
I have a database which generates up to 5000 items. the
3 fields are PAGE_NUM, ITEM AND CODE. I'd like to have 2
fields added which enables the visitor to enter a quantity
and a comment on each record, pressing submit I'd like a
confirmation page of only the records without null values
and a few fields for them to enter their name and info.
At this point they'd need to press a button to confirm
which would generate an e-mail to them and a text file to
myself.
