Linking Many Tables What can I do?

[MariaMaria]

I am building an access db that is for a hospital to track various patient elements, but the amount of is > 255 so I created various 12 tables but I'm having trouble trying to link them. Should I link them all back to a patient identifier table?

Any help would be great!

 

[dhookom]

You should normalize your table so that you have much less than 255 fields. It would be unusual if your table needed more than about 30 fields.

If you provide some information about the fields, someone might be able to help you with the normalization.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886