How d I link records to one another in different tables

I pulled this very convoluted database from ACCESS and I had to split the tables, apprently I have impotred them into an SQL structure. The tables appear to have retained all of their relations. However, when I look at patients and scroll through that database the patient visits database is supposed to point to the visits which correspond to that patient, via the patient ID field in both. The designer says that there is a relation only link between the two tables, but the are both simply flat tables. This is supposed to be a relational database, as it was in ACCESS. Any ideas as to what might be going on? I have done a lo tof programming in relational databases, paradox, access, DB II, DB IV Alpha, etc but I am stumped on this.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

can you run a query like
Select * From Visit where PatientID = x

if you're getting the right results then the tables are setup properly.

Now if this is not true how about you post the table definitions here.

if you right click on the name of the table in SQL Server Management Studio (SSMS) then you could Click Script Table As>Create To> New Query Window.

Copy the code here and we could probably help you with it more.

Are you saying a database when in fact you mean a table?  Is your final result in Access or in SQL Server 2005?
evaultAuthor Commented:
Looks like Access as the database which contains the tables, is an .mdb.
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

evaultAuthor Commented:
That should read:
Looks like Access, as the database, which contains the tables, is an .mdb

Further when ,I use SQL Manager, from EMS, this particular database does not show in the list of SQL databases that are currently running.
If you're looking in SQL Manager an access database shouldn't appear.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
evaultAuthor Commented:
OK. SO it sounds like when I connect to them into VB 2008 Express it connects to it as an Access DB. That would make sense, but it looks like the wizards are kind of misleading as they appear to make it look like you are connecting to an Access DB as an SQL DB.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.