Picklist

  • Thread starter Thread starter Frolickin
  • Start date Start date
F

Frolickin

Way back when I requested help with creating a picklist. Someone was very
kind and sent along this url:
http://www.spiderwebwoman.com/tutorials/picklist.htm

That worked great for what I was doing, but now have a slightly different
task that is not working the way I had hoped.

If we use the example from that url, instead of creating the picklist from
the ID, I would like to create the picklist from the field COMPANY. I can,
of course, do this easily. The problem arises in that Ford will be listed
seven times, Chevrolet four times, etc. What I desire is for each company
to be listed but once.

I created another table that lists just the companies. I used DRW to make
that a table on one page. I used the steps to create the hyperlink to
display.asp, but that didn't pass the variable properly. I gather I am
missing something. I am using FP2003.

I would appreciate some help.

Thank you kindly,
Fro.
 
I should also point out that I modified display.asp. Instead of listing by
ID, I listed by Company.

When I run a test case on this with a search form, all Fords, Chevys, etc.
are returned as expected. It is when I try to generate the query from
another .asp page with a picklist that I run into the troubles I mentioned
in the first post.
 
In your query, you need to use:

Distinct(Company), field, field From table

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Thomas A. Rowe said:
In your query, you need to use:

Distinct(Company), field, field From table
Click to expand...

Thank you. That solved the repeating problem.

Still existing is that this variable is not passed on properly to the next
page. I think the problem resides in that the picklist tutorial is to pick
a specific record. Because I modified display.asp to show a number of
records, things aren't displaying properly. No records are returned.

:(
 
If the Company has an ID, then you need to also retrieve that in your query and then in your drop
down menu use the ID as the Selection Value, then on your next page use that value to query the
database for the specific record.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Back
Top