Hi any help would be appreciated.

I have a SQL 2000 DB where one table holds details on Car Dealers. The second Table holds info on the cars being sold.

This DB is to searched via a Website.

I wanted to cut down time by only inputting Dealer info once in the Dealer Table.

I have created a diagram between the two tables relating the ID column of the Dealers Table to the Dealers column in the Vehicle table. I believed that all I would need was to input the ID of the dealer for each car to link to that specific dealer.

However when searched with the web page, the only dealer info displayed on every page is that of the dealer with ID 1.

2,3,4 etc do not show.

Any help with this would be greatly appreciated as I only ever end up running round in circle trying to figure out SQL.

Thanks in advance.
Matt

have you added a repeat region to the info? if not, only the first returned will be displayed on the page..

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

Thanks,

Yes I have a repeat region, its the info from the DB that only showing once the pages aren't a prob

matt

can you post the code from the recordset so I can see it...sure we can fix this for you

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting