2. ASPRunnerPro General questions
  3. Access mdb relationships multiple tables
This topic is locked

Access mdb relationships multiple tables

 		8/13/2003 11:19:29 AM
ASPRunnerPro General questions
M
 MaxLm author

How do you select in ASPRUNNER (trial version) to display for editing or deleting or adding a screen that has integrity relationships with other tables.
ie:

tblMaster

Id
tableNames

Id

FName

Lastname
tblAddress

Id

Street, City, State, Zip, Country
tblVerification

Id

SSNumber

DLNumber

BusinessLicNumber
ETc. etc.
On my application, this only shows on one screen and able to do add, edit, delete depending on security.
Please advise.

thanks
Sergey Kornilov admin 8/13/2003

Hi,
could you clarify what "screens" do you mean?
Sergey Kornilov
M
 		MaxLm author 8/13/2003

HI Sergey-

On my VB6 screen, I use one User Interface for multiple related tables.
I want to be able to select on ASPrunner the fields from the above access tables to display to the user. Is this possible?
Show the following from multiple tables on single asp page:
tblNames.FName

tblNames.Lastname

tblAddress.Street

tblAddress.City

tblAddress.State

tblAddress.Zip

tblAddress.Country

tblVerification.SSNumber

tblVerification.DLNumber

tblVerification.BusinessLicNumber
thanks,
M
 		MaxLm author 8/14/2003

Any reply to this?
I guess ASPrunner only support single table per ASPpage???
Sergey Kornilov admin 8/14/2003

Hi,
While running ASPRunner go to the Edit SQL query manually page (step 5 of 11).

On this page you can edit default SQL query to get data from multiple joined tables etc. Do not forget to read SQL query guidelines on that page.
Sergey Kornilov
M
 		MaxLm author 8/14/2003

OH... This is a little more involved... Are there real life examples to do this? Will check that info and see if can do it or not.
Thanks,
Sergey Kornilov admin 8/14/2003

Here is the example. I use test MS Access Northwind database.
I select Orderstable and add several fields to the list. Here is the default SQL query:

select [OrderID],

[EmployeeID],

[OrderDate],

[RequiredDate],

[ShippedDate]

From [dbo].[Orders]


I change this code manually to add field from the joined table

select [OrderID],

ContactName,

[EmployeeID],

[OrderDate],

[RequiredDate],

[ShippedDate]

From [dbo].[Orders]  a

inner join customers b

on a.customerid=b.customerid


I hope this helps.
Sergey Kornilov