Multiple Table Access

  • Thread starter Thread starter Marc Jones
  • Start date Start date
M

Marc Jones

I have a project management program made up of three
tables: Projects, Contacts, Properties with a Project_Link
table that associates projects w/ contacts and properties.
My question is this. When I pull up a project display page
I need to associate that Project ID with the Project_Link
page, acquire the Contact_ID's and look up that data in
the Contacts table. I have the following:

<% Set CRS = Server.CreateObject("ADODB.Recordset")
CRS.ActiveConnection = Conn

SQL = "SELECT * FROM Project_Link where Project_ID = !!
This is where I want to pass the Project ID from the page.

CRS.Open SQL
%>
I can't seem to get the Project_ID passed dynamically from
the current page. Any ideas.
 
Hi,


I am not an expert in ASP kind of work, but seems to me you may try:

SQL = "SELECT * FROM Project_Link where Project_ID = " + myProjectID




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top