DIW Query Source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

FP2002 web with Access 2002 DB

I want to use the DBIW with an existing QUERY as my source, not a table.
The query mimics the table except it has the fields in a different order (has
to be this way for other reasons). Although the DIW dialog boxes ask the
user to choose a table of "VIEW" (where I am assuming "view" is a query),
only tables are listed as options.

Can I create a DBI using an existing access query as a source rather than a
table? If so, how can I do this since the queries are not listed in the
wizard pages?

THANK YOU
 
Thanks for the quick and thoughtful response. You've been so helpful to me
on so many varied FP/Access issues - THANK YOU!

I'm unsure of what you suggest I do on this one. At the risk of being
redundant, let me try to restate my goal: lWhat I need to do is allow others
to EDIT records from the tblPlayers ...but I can't use the tblPlayers as my
DBIW source because the primary key field is not the first column in that
table (and I need to keep it that way). I would like to use a QUERY as my
DIW source so I can put the primary key field in the 1st column position
which will then allow me to correctly select/edit my individual tblPlayer
records as necessary. Since the DBIW dialog box asks the creator to select a
Table or VIEW, it would seem that queries are permissable as the
source....but they aren't listed. I thought of creating all of the DBI pages
the wizard will create for me and then modifieng each one to use a query as
the source rather than a table...but that certainly seems tedious and error
prone. Is there no other way???
 
The query that I want to use as the source for the DBI is not a make-table
query. However, making a new table, and constantly updating it as the
records will change daily, seems to be the only option here. I LINKED a new
table to my existing tblPlayers BUT the DBIW doesn't recognize Linked Tables.
Thanks for your assistance.
 
FYI: You can use any field, in any order, as a lookup field, and the field doesn't have to be a
primary key field via ASP/VBScript

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
Back
Top