Change Record Order in DB Interface Wizard

[Guest]

Is there a way I can change the order the records are pulled into the DB Interface Wizard? For example, let's assume I have two fields in a table; Name and NameID. When I run the DBIW to gain the ability to edit/delete records out of the database, it makes the first field as a hyperlink in the database_editor.asp. My trouble is that I want the NameID field to be the hyperlink field.

 

[Kevin Spencer]

YOu can modify your query by adding an ORDER BY clause. Example:

SELECT * FROM MyTable ORDER BY SomeColumn ASC

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

Is there a way I can change the order the records are pulled into the DB

Interface Wizard? For example, let's assume I have two fields in a table;
Name and NameID. When I run the DBIW to gain the ability to edit/delete
records out of the database, it makes the first field as a hyperlink in the
database_editor.asp. My trouble is that I want the NameID field to be the
hyperlink field.

 

[Mike]

switch the two fields (NameID and Name), then copy the hyperlink tag from
Name to NameID and delete the hyperlink from Name.

Mikeal

Is there a way I can change the order the records are pulled into the DB

Interface Wizard? For example, let's assume I have two fields in a table;
Name and NameID. When I run the DBIW to gain the ability to edit/delete
records out of the database, it makes the first field as a hyperlink in the
database_editor.asp. My trouble is that I want the NameID field to be the
hyperlink field.