Pulling Data from two databases

[Dennis Burgess]

I have table part

it has

ID
partno
custid
date

I have another SQL database, that i have a connection too, that has a part
table

in it I have

id
partno
title
description
msrp

I want to display a line, that shows the part, title, descp and msrp.. the
part would come from the part table, with the rest comming from another
database.

Suggestions?

Thanx in advance.

Dennis

 

[Dennis Burgess]

I moved the two tables to the same database as my description. I made a
view, that shows part, title and description and msrp. However, I then
joined the two partno fields, and I am getting like 100s of parts, the part
table that I created just has one part number.

Dennis