Greetings,
I am attempting to create an animal hospital data base. I was wondering if anyone would be able to help me with my relationships before I start entering patient records and run into endless troubles down the road. Here are somethings you should know:
1) this was recreated for confidentiality reasons toward patient owners and therefore can NOT contain ANY owner information.
2) I have created a multivalued lookup field in tblpatients. I have been told these kinds of things can cause some trouble and I have also read some information on these troubles but couldn't quite wrap my head around it. The thing is, it's imperative that I have such a field because patients may undergo more than one procedure in a single day.
3) I understand that there are special characers and extremely long headers in the tables, but I will be conferring with my supervisor to break them down to much simpler ones.
4) I am operating on Windows 10 OS, and am running access 2007 not 2010 as it may show.
I look forward to anyone that can help me, thanks!
P.S. My Database is a smidge too big to upload here so if you must take a look at the file you can email me as well at: buchnyalex@gmail.com