lookup tables

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

Guest

I am trying to create a series of data entry web pages from an Access
database. The database is basically a one main table with 3 other lookup
tables. The problem I am running into is I cannot access the information
stored in the lookup tables. These lookup tables/fields are a vital part of
the data entry for these sites. How can I integrate them into the web pages?
 
You need to open a separate record set for each of the tables
or use Joins (to the other tables) when you open the main table
Post a snippet of your SQL statement

--




|I am trying to create a series of data entry web pages from an Access
| database. The database is basically a one main table with 3 other lookup
| tables. The problem I am running into is I cannot access the information
| stored in the lookup tables. These lookup tables/fields are a vital part of
| the data entry for these sites. How can I integrate them into the web pages?
 
Thanks for the reply.

Do you mean the SQL statement that I'd like the use; the one that works in a
regular Access query/form or the SQL statement I should find in Front Page
somewhere?

(I've only been using Front Page for about 8 hours)

Danielle
 
By the way, I should mention that I need to be able to use this page to add
data to my main table. I want the website to be a form and not just a view of
the data. I'm only mentioning this because using a query as the basis of the
page will sometimes freeze the table (at least it does in Access).
 
Look at File New (more Website Template at the DIW)
- but what you are attempting to do w/ multiple related tables will require custom hand coded ASP

--




| By the way, I should mention that I need to be able to use this page to add
| data to my main table. I want the website to be a form and not just a view of
| the data. I'm only mentioning this because using a query as the basis of the
| page will sometimes freeze the table (at least it does in Access).
|
| "Stefan B Rusynko" wrote:
|
| > You need to open a separate record set for each of the tables
| > or use Joins (to the other tables) when you open the main table
| > Post a snippet of your SQL statement
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > |I am trying to create a series of data entry web pages from an Access
| > | database. The database is basically a one main table with 3 other lookup
| > | tables. The problem I am running into is I cannot access the information
| > | stored in the lookup tables. These lookup tables/fields are a vital part of
| > | the data entry for these sites. How can I integrate them into the web pages?
| >
| >
| >
 
Aw, that's bad news. Can I integrate an Access web page into a FrontPage
website? I have an Access page that currently does the lookup thing properly.
I went to Front Page because I wanted to be able to have another web page
with filtering that still allowed the tables to be modified. Basically I have
a data entry page and want a reviewers page that would only show the
reviewers items that hadn't yet been reviewed, but they could review through
the same website.

I started with the linked table page because I thought it would be easier to
do all the pages in one program but if I have to combine (and if I can
combine) and Access page and a FrontPage page then that works for me.

Stefan B Rusynko said:
Look at File New (more Website Template at the DIW)
- but what you are attempting to do w/ multiple related tables will require custom hand coded ASP

--




| By the way, I should mention that I need to be able to use this page to add
| data to my main table. I want the website to be a form and not just a view of
| the data. I'm only mentioning this because using a query as the basis of the
| page will sometimes freeze the table (at least it does in Access).
|
| "Stefan B Rusynko" wrote:
|
| > You need to open a separate record set for each of the tables
| > or use Joins (to the other tables) when you open the main table
| > Post a snippet of your SQL statement
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > |I am trying to create a series of data entry web pages from an Access
| > | database. The database is basically a one main table with 3 other lookup
| > | tables. The problem I am running into is I cannot access the information
| > | stored in the lookup tables. These lookup tables/fields are a vital part of
| > | the data entry for these sites. How can I integrate them into the web pages?
| >
| >
| >
Click to expand...
 
The Access application is not used on the web, so you would have to custom code this in ASP/VBScript
to have the same functionality.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

DBlake said:
Aw, that's bad news. Can I integrate an Access web page into a FrontPage
website? I have an Access page that currently does the lookup thing properly.
I went to Front Page because I wanted to be able to have another web page
with filtering that still allowed the tables to be modified. Basically I have
a data entry page and want a reviewers page that would only show the
reviewers items that hadn't yet been reviewed, but they could review through
the same website.

I started with the linked table page because I thought it would be easier to
do all the pages in one program but if I have to combine (and if I can
combine) and Access page and a FrontPage page then that works for me.

Stefan B Rusynko said:
Look at File New (more Website Template at the DIW)
- but what you are attempting to do w/ multiple related tables will require custom hand coded ASP

--




| By the way, I should mention that I need to be able to use this page to add
| data to my main table. I want the website to be a form and not just a view of
| the data. I'm only mentioning this because using a query as the basis of the
| page will sometimes freeze the table (at least it does in Access).
|
| "Stefan B Rusynko" wrote:
|
| > You need to open a separate record set for each of the tables
| > or use Joins (to the other tables) when you open the main table
| > Post a snippet of your SQL statement
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > |I am trying to create a series of data entry web pages from an Access
| > | database. The database is basically a one main table with 3 other lookup
| > | tables. The problem I am running into is I cannot access the information
| > | stored in the lookup tables. These lookup tables/fields are a vital part of
| > | the data entry for these sites. How can I integrate them into the web pages?
| >
| >
| >
Click to expand...
Click to expand...
 
Back
Top