Dear Richard,
Your tutorials I purchased some few weeks ago has made a change to my understanding of database.
I am developing a database for my personal use by logging all surgeries I perform in order not to be chasing the statistician for help.
My questions are:
1. Is it right to create an input form from tables or from queries?
2. Is it correct to create patient diagnosis and surgeries performed using a subform on the main input form derived from tables since a patient can have many diagnosis and surgeries on a single visit?
I’ve attached my tables to this mail. Please pay attention to my relational tree and primary as well as foreign keys. I need you to inspect my work. There is more ahead with the work.
Thank you for your cooperation.
Samuel.