Let me start by saying I've been lurking these boards for months and I'm forever greatful for the constant flow of information. I learn something new ever time I log on! I'm hoping some of you might have suggestions on the project I just received.
I have been tagged to bring together three departments that bring patients into our hospital requiring beds. Prior to this undertaking each dept would fill out similar forms and fax them back and forth to request and then assign beds.
I've broken down all the forms into what I can figure is a normalized state. I'm still learning as this is only my third MSAccess DB ever. This DB is quite a bit larger than my previous DBs where proper normalization and relationships weren't as mission critical.
I've attached a .jpg of the relationships. Any comments or suggestions would be greatly appreciated!