How to load a lookup list from the database

[Merdaad]

Hi,

In my frontpage application form,I want to load a list from the database
(the list should be invisible). Then when I enter new data onto my form, I
would like to be able to search the hidden list and make sure I don't
duplicate any of the items in that list?
I tried loadeing the list using the insert-database-results and then load
the list to a dropdown. But the dropdown is visible and would be confusing
to the user. I am sure there are better ways to load database data so you
can lookup items, Would anyone know how?

Thanks
Merdaad

 

[Stefan B Rusynko]

Not w/ the DBRW
You will need to hand code your ASP on your form processing page (not the form page) to query the DB and look for dupes

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hi,
|
| In my frontpage application form,I want to load a list from the database
| (the list should be invisible). Then when I enter new data onto my form, I
| would like to be able to search the hidden list and make sure I don't
| duplicate any of the items in that list?
| I tried loadeing the list using the insert-database-results and then load
| the list to a dropdown. But the dropdown is visible and would be confusing
| to the user. I am sure there are better ways to load database data so you
| can lookup items, Would anyone know how?
|
| Thanks
| Merdaad