Hey there,. I have created a web site in DREAMWEAVER and a database using ACCESS.

In DREAMWEAVER we have created a
Search Page
Results Page
Details Page

In ACCESS we have created 6 tables.
All tables have relationships to each other.

When you search the database on the internet. Your results come up fine but the results still show the relationship number rather than the results.

Example of an address would be.

Search Result: Joe Bloggs 41 Dempster Street T1 S1 3204 C1

T1 result should be the Town
S1 results should be the Statge
C1 result should be the Country.

Can anyone suggest what to look for here or where I may have gtone wrong?

Thanks in advance.

Mal R.

either you have set the wrong relationships, or you need to use JOIN in the sql, to gather the correct info instead of the ID.

regards

Dave Thomas
<b>DMX Zone Manager</b>

Dave, thansk for the reply. I will have a good look at that.

Thanks for the support offered.

Mal.

have you used the query builder that comes with access?

i have some example pics if you need to see them.

regards

Dave Thomas
<b>DMX Zone Manager</b>