Relating Tables in Access

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

sadlerdcs

Thread Starter
Joined
Dec 7, 2005
Messages
5
New to Access and am having difficulty with making relationships with access. I have a database which is based off of a form and we use in our company and I created a series of tables:
patient - list contact info
Accidents observation
Mental Status
Ambulation
Transfers
Status Prior to occurence
Equipment involved
factors
Report - list date, time & nursing staff notified
Relative Contact

I'm looking for assistance in relating these tables so information is updated correctly and I can run reports. Any assistance would be helpful
 

OBP

Joined
Mar 8, 2005
Messages
19,896
How many fields in each table, do you have an accident key field that is used in each table?
If you want help on here it is best to post a zipped copy.
If you want my help send me a private email by clicking on my name.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top