Originally Posted by
orange
I think you are mixing analysis with design. Get a clear statement of WHAT you are trying to do-in simple English (or native language). Get your tables and relationships identified based on your business rules/facts. Test the model with test data and scenarios (pencil and paper). Adjust the model/data/facts as necessary until scenarios reflect your rules.
Then work out the interface (forms and reports) for implementation in Access.
Major entities:
Patients
treatment room(s)
PatientPosition
RoomCapacity