MS Access and ASP pages

M

Mike

Hi

I have a page on my website connected to an Access database. I can
access a query and publish the results on the page OK. I am trying to
update the database via a web page and have been successful in updating
one of the tables(GigVenues). The problem I have is updating two tables
together( One tables FK references the PK of the other) Frontpage only
allows me to select one table!

Table 1: GigVenues: VenueID(PK Autonumber),VenueName, VenueAddress, etc
Table 2: GigDates: GigID (PK) Autonumber),GigDate, VenueID(FK references
GigVenues)

What I need to do is to be able to update the GigDates table and to have
a Combo box to select the VenueName in the GigVenues table, but I can
only connect to one table at a time and the VenueID(FK)in the same table
is no good without being able to see the VenueName.

Thanks in anticipation

Regards
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Adding data to MS Access from csv file 0
Help creating a search form in Access XP 0
How to have two tables on same line? 1
Creating a Search using a combo box and then creating a report. 4
Child Table With Two Parent Tables 4
Setting column width in a table with a macro is not working 0
List all tables, including document structure 0

Top