Dual Field Drop Downs, Grid To Form New Window

[Peter Jameson]

Hi,
We are trying to get a drop down box from our initial search form to
contain two fields combined. For example, we have a dealer location
field containing three characters and a Dealer Number field containing
six characters. We want our drop down box to contain all nine characters.
Does anyone know if this is possible?

Second question deals with the grid to form issue. Basically we want to
have a grid with the gridindex as the hyper link. Upon clicking one of the
hyperlinks a new window should open up with that record in form view. We
have been able to accomplish this, however the big feature we have not been
able to accomplish is having the form view be able to move forward and
backwards through the recordset.

If anyone has any insight into this I would greatly appreciate it.

Thankx in advance,
Peter Jameson
JPSF & Associates

[Frank]

Peter,
#1 - Combined field dropdown.
YOu can accomplish that by have a computed field like -

SELECT you fields,... Location3 & " " & DealerNumber as special FROM tablename

Now you have drop down from the calculated field.

#2 -Use dbMode="Dual-horiz" or "both" or "dual" they all change records upon clicking the index.

Hope this help.

Frank


On 9/20/98 2:22:00 PM, Peter Jameson wrote:
> Hi,

We are trying to get a drop down box from our initial search form
> to
contain two fields combined. For example, we have a dealer
> location
field containing three characters and a Dealer Number field
> containing
six characters. We want our drop down box to contain all nine
> characters.
Does anyone know if this is possible?

Second question deals
> with the grid to form issue. Basically we want to
have a grid with the
> gridindex as the hyper link. Upon clicking one of the
hyperlinks a new
> window should open up with that record in form view. We
have been able
> to accomplish this, however the big feature we have not been
able to
> accomplish is having the form view be able to move forward and
backwards
> through the recordset.

If anyone has any insight into this I would
> greatly appreciate it.

Thankx in advance,
Peter Jameson
JPSF & Associates

Frank,

Thanks for the feedback. The dual field drop down seems to be getting
more complex. I need the dropdown to be a search field, actually
a dbfilterdropflds. This does not seem to allow me to select two fields
as the contents of the drop down box.

#2 the dual works exactly as I would like it to with the exception
that when a user selects one of the gridindex links I want a new browser
window to open rather than have the same window be adjusted to include the
form version of the record. Ideally this new browser window would enable to
user to move forward and backwards through the recordset.

Perhaps it would be easier to explain it this way. When the user selects
a grid index link. I would like to:
1) open a new browser window
2) Use the same recordset
3) set dbMode to Form
4) goto the record the user clicked
5) enable navigation next and previous that coincides with the
grid view.

Thankx again,

Peter Jameson
JPSF & Associates
On 9/20/98 3:12:29 PM, Frank wrote:
> Peter,
#1 - Combined field dropdown.
YOu can accomplish that by have a
> computed field like -

SELECT you fields,... Location3 & " " &
> DealerNumber as special FROM tablename

Now you have drop down from the
> calculated field.

#2 -Use dbMode="Dual-horiz" or "both" or "dual" they
> all change records upon clicking the index.

Hope this
> help.

Frank


On 9/20/98 2:22:00 PM, Peter Jameson wrote:
> Hi,
>

We are trying to get a drop down box from our initial search form
>
> to
contain two fields combined. For example, we have a dealer
>
> location
field containing three characters and a Dealer Number field
>
> containing
six characters. We want our drop down box to contain all nine
>
> characters.
Does anyone know if this is possible?

Second question
> deals
> with the grid to form issue. Basically we want to
have a grid
> with the
> gridindex as the hyper link. Upon clicking one of the
>
hyperlinks a new
> window should open up with that record in form view.
> We
have been able
> to accomplish this, however the big feature we
> have not been
able to
> accomplish is having the form view be able to
> move forward and
backwards
> through the recordset.

If anyone has
> any insight into this I would
> greatly appreciate it.

Thankx in
> advance,
Peter Jameson
JPSF & Associates

[Peter Jameson]

Frank,

Thanks for the feedback. The dual field drop down seems to be getting
more complex. I need the dropdown to be a search field, actually
a dbfilterdropflds. This does not seem to allow me to select two fields
as the contents of the drop down box.

#2 the dual works exactly as I would like it to with the exception
that when a user selects one of the gridindex links I want a new browser
window to open rather than have the same window be adjusted to include the
form version of the record. Ideally this new browser window would enable to
user to move forward and backwards through the recordset.

Perhaps it would be easier to explain it this way. When the user selects
a grid index link. I would like to:
1) open a new browser window
2) Use the same recordset
3) set dbMode to Form
4) goto the record the user clicked
5) enable navigation next and previous that coincides with the
grid view.

Thankx again,

Peter Jameson
JPSF & Associates
On 9/20/98 3:12:29 PM, Frank wrote:
> Peter,
#1 - Combined field dropdown.
YOu can accomplish that by have a
> computed field like -

SELECT you fields,... Location3 & " " &
> DealerNumber as special FROM tablename

Now you have drop down from the
> calculated field.

#2 -Use dbMode="Dual-horiz" or "both" or "dual" they
> all change records upon clicking the index.

Hope this
> help.

Frank


On 9/20/98 2:22:00 PM, Peter Jameson wrote:
> Hi,
>

We are trying to get a drop down box from our initial search form
>
> to
contain two fields combined. For example, we have a dealer
>
> location
field containing three characters and a Dealer Number field
>
> containing
six characters. We want our drop down box to contain all nine
>
> characters.
Does anyone know if this is possible?

Second question
> deals
> with the grid to form issue. Basically we want to
have a grid
> with the
> gridindex as the hyper link. Upon clicking one of the
>
hyperlinks a new
> window should open up with that record in form view.
> We
have been able
> to accomplish this, however the big feature we
> have not been
able to
> accomplish is having the form view be able to
> move forward and
backwards
> through the recordset.

If anyone has
> any insight into this I would
> greatly appreciate it.

Thankx in
> advance,
Peter Jameson
JPSF & Associates

[Frank]

Peter,
There is no support of openning of a "different" browser upon a link. Even if it is implemented, there`ll be a "new" browser "every time" a link is clicked and that would be even worst.

As for the drop down, it is real easy to creat a compute filed and there are special provisions in aspdb to search on the computed fields. There should be an example in the aspdb.com illustrating that.

Frank


On 9/20/98 5:44:30 PM, Peter Jameson wrote:
> Frank,

Thanks for the feedback. The dual field drop down seems to be
> getting
more complex. I need the dropdown to be a search field, actually
>
a dbfilterdropflds. This does not seem to allow me to select two
> fields
as the contents of the drop down box.

#2 the dual works exactly
> as I would like it to with the exception
that when a user selects one of
> the gridindex links I want a new browser
window to open rather than have
> the same window be adjusted to include the
form version of the record.
> Ideally this new browser window would enable to
user to move forward and
> backwards through the recordset.

Perhaps it would be easier to explain
> it this way. When the user selects
a grid index link. I would like
> to:
1) open a new browser window
2) Use the same recordset
3) set dbMode
> to Form
4) goto the record the user clicked
5) enable navigation next and
> previous that coincides with the
grid view.

Thankx again,

Peter
> Jameson
JPSF & Associates
On 9/20/98 3:12:29 PM, Frank wrote:
>
> Peter,
#1 - Combined field dropdown.
YOu can accomplish that by have a
>
> computed field like -

SELECT you fields,... Location3 & " " &
>
> DealerNumber as special FROM tablename

Now you have drop down from the
>
> calculated field.

#2 -Use dbMode="Dual-horiz" or "both" or "dual"
> they
> all change records upon clicking the index.

Hope this
>
> help.

Frank


On 9/20/98 2:22:00 PM, Peter Jameson wrote:
> Hi,
>
>

We are trying to get a drop down box from our initial search form
>
>
> to
contain two fields combined. For example, we have a dealer
>
>
> location
field containing three characters and a Dealer Number field
>
>
> containing
six characters. We want our drop down box to contain all
> nine
>
> characters.
Does anyone know if this is possible?

Second
> question
> deals
> with the grid to form issue. Basically we want
> to
have a grid
> with the
> gridindex as the hyper link. Upon
> clicking one of the
>
hyperlinks a new
> window should open up with
> that record in form view.
> We
have been able
> to accomplish this,
> however the big feature we
> have not been
able to
> accomplish is
> having the form view be able to
> move forward and
backwards
>
> through the recordset.

If anyone has
> any insight into this I would
>
> greatly appreciate it.

Thankx in
> advance,
Peter Jameson
JPSF &
> Associates

[John]

Hi Peter,

As far as opening a "second" window when the user clicks on a "drill-down" field, and having that window shown in form mode, it`s pretty easy with a few lines of JavaScript! You`ll have TWO ASP programs. We`ll call them
javawindow1.asp and javawindow2.asp. The javawindow1.asp will display the
data in "grid" mode, and the "2" window will show it in "form" mode. In the
javawindow1.asp program, you`d create a function in your <head> with code like this:

<HEAD>
<SCRIPT LANGUAGE="JavaScript">
<!-- Hide from old browsers...
var wind = null
function second_wind(idval) {
var loc = "javawindow2.asp?id=" + idval;
if (wind == null) {
wind=window.open(loc ,"window_two");
} else {
wind.location = loc;
wind.focus();
}
}
//-->
</SCRIPT>
</HEAD>

This just creates a quick little JavaScript function called "second_wind" which when called with a "UniqueID" value will open another window, load up a file in it called "javawindow2.asp", and pass it the UniqueID value on the URL. In the javawindow2.asp file you can then retrieve that value with Request("id") and use it in your dbSQL such as:

MyDb.dbSQL = "SELECT * FROM Table1 WHERE ID = `" & Request("id") & "`"


The way you call the second_wind function and pass it the UniqueID value is to simply use the dbMagicCell property (what else!). Here`s how it might
look (in javawindow1.asp):

MyDb.dbMagicCell =
"UniqueID,,<A HREF=""JavaScript:second_wind(#UniqueID#)"">#Uniqu eID#</A>"

This creates a cell that looks like this:

<A HREF="JavaScript:second_wind(12345)">12345</A>


By the way, it won`t keep creating new windows since we just look at the "wind" variable and if it`s already there, we don`t create another one.

Hope this helps you on your way..
John


On 9/20/98 7:33:29 PM, Frank wrote:
> Peter,
There is no support of openning of a "different" browser upon a
> link. Even if it is implemented, there`ll be a "new" browser "every time" a
> link is clicked and that would be even worst.

As for the drop down, it
> is real easy to creat a compute filed and there are special provisions in
> aspdb to search on the computed fields. There should be an example in the
> aspdb.com illustrating that.

Frank


On 9/20/98 5:44:30 PM, Peter
> Jameson wrote:
> Frank,

Thanks for the feedback. The dual field drop
> down seems to be
> getting
more complex. I need the dropdown to be a
> search field, actually
>
a dbfilterdropflds. This does not seem to
> allow me to select two
> fields
as the contents of the drop down
> box.

#2 the dual works exactly
> as I would like it to with the
> exception
that when a user selects one of
> the gridindex links I want a
> new browser
window to open rather than have
> the same window be
> adjusted to include the
form version of the record.
> Ideally this new
> browser window would enable to
user to move forward and
> backwards
> through the recordset.

Perhaps it would be easier to explain
> it this
> way. When the user selects
a grid index link. I would like
> to:
1)
> open a new browser window
2) Use the same recordset
3) set dbMode
> to
> Form
4) goto the record the user clicked
5) enable navigation next and
>
> previous that coincides with the
grid view.

Thankx
> again,

Peter
> Jameson
JPSF & Associates
On 9/20/98 3:12:29 PM,
> Frank wrote:
>
> Peter,
#1 - Combined field dropdown.
YOu can
> accomplish that by have a
>
> computed field like -

SELECT you
> fields,... Location3 & " " &
>
> DealerNumber as special FROM
> tablename

Now you have drop down from the
>
> calculated
> field.

#2 -Use dbMode="Dual-horiz" or "both" or "dual"
> they
> all
> change records upon clicking the index.

Hope this
>
>
> help.

Frank


On 9/20/98 2:22:00 PM, Peter Jameson wrote:
> Hi,
>
>
>

We are trying to get a drop down box from our initial search form
>
>
>
> to
contain two fields combined. For example, we have a dealer
>
>
>
> location
field containing three characters and a Dealer Number
> field
>
>
> containing
six characters. We want our drop down box to
> contain all
> nine
>
> characters.
Does anyone know if this is
> possible?

Second
> question
> deals
> with the grid to form issue.
> Basically we want
> to
have a grid
> with the
> gridindex as the
> hyper link. Upon
> clicking one of the
>
hyperlinks a new
> window
> should open up with
> that record in form view.
> We
have been able
>
> to accomplish this,
> however the big feature we
> have not
> been
able to
> accomplish is
> having the form view be able to
>
> move forward and
backwards
>
> through the recordset.

If anyone
> has
> any insight into this I would
>
> greatly appreciate
> it.

Thankx in
> advance,
Peter Jameson
JPSF &
> Associates