DIW Query Source

[MaureenKLM]

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

 

[Kathleen Anderson [MVP - FrontPage]]

I don't think you can. What you could do, however, is create a Database
Results Query page using the View as the source, and pass the results to a
page in the DBIW.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[MaureenKLM]

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???

 

[Kathleen Anderson [MVP - FrontPage]]

Is your Access Query a Make Table Query?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[MaureenKLM]

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.

 

[Thomas A. Rowe]

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
==============================================