hi,
I would like to ask if it is possible to do the following. I have a Whats New mod installed into my Dbman. I would like to show the latest 50 records for "male" and the latest 50 records for "female". (There is a field called "Sex" that is a drop down menu to choose either "male" or "female".)

could any one tell me how to do it??

Thanks in advance

It's just a search, with an added field -- anyway the current mod is.

Create a form to do the search, including your select list for 'Sex'. Also include a hidden field




------------------
JPD

Two suggestions:

1) Add a field for the New Records in your search form.

2) Hard-code links that will go to the newest records for each value of the field you want.

Example:


AND


Regards,

------------------
Eliot Lee....
Former Handle: Eliot
Anthro TECH, L.L.C
anthrotech.com
* Check Resource Center
* Search Forums
* Thinking out of the box (codes) is not only fun, but effective.




[This message has been edited by AnthroRules (edited May 10, 2000).]

The way the What's New mod is set up now, what he would use is


The latest version of What's New does all of the computation within sub query.


------------------
JPD

THanks for both of your sugguestion


it works like a charm now!!

Thanks

Good...and you're welcome.

Regards,

------------------
Eliot Lee....
Former Handle: Eliot
Anthro TECH, L.L.C
anthrotech.com
* Check Resource Center
* Search Forums
* Thinking out of the box (codes) is not only fun, but effective.