M
mac
Can I change the label on a field dependent upon the
value that is in another field in the same query? I am
using fp2003 DRW to a SQL database using asp pages. The
first page is a dropdown list that sends a userid to the
second page which is then input to a query that displays
the components assigned to that user. The queries work
and display data but some fields use generic labels.
For example, the component field in the record can be
several values, ie.. phone, circuit, server. Additional
fields in the same record are labeled Attrib1, Attrib2,
etc.. and they contain values which describe attributes
of the component.
The data is;
Comp = phone / attrib1 = area code
Comp = Circuit / attrib1 = point-point
Comp = Server / attrib1 = cluster
So I want the label to reflect the data in the attrib
field;
If comp = phone, change the attrib1 label to Area Code
If comp = circuit, change the attrib1 label to point-point
etc...
The database layout may sound strange, but it is a
vendors database and I cannot modify it.
value that is in another field in the same query? I am
using fp2003 DRW to a SQL database using asp pages. The
first page is a dropdown list that sends a userid to the
second page which is then input to a query that displays
the components assigned to that user. The queries work
and display data but some fields use generic labels.
For example, the component field in the record can be
several values, ie.. phone, circuit, server. Additional
fields in the same record are labeled Attrib1, Attrib2,
etc.. and they contain values which describe attributes
of the component.
The data is;
Comp = phone / attrib1 = area code
Comp = Circuit / attrib1 = point-point
Comp = Server / attrib1 = cluster
So I want the label to reflect the data in the attrib
field;
If comp = phone, change the attrib1 label to Area Code
If comp = circuit, change the attrib1 label to point-point
etc...
The database layout may sound strange, but it is a
vendors database and I cannot modify it.