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.

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.

"AC" <(E-Mail Removed)> wrote in message
news:501D3C6A-AC7F-4501-9497-(E-Mail Removed)...
> 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.

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

Mikeal

"AC" <(E-Mail Removed)> wrote in message
news:501D3C6A-AC7F-4501-9497-(E-Mail Removed)...
> 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.