Recent content by Xiael

Alright, see that makes sense and is one of the things that was confusing me when I had it all laid out. I was just trying to link everything with the appropriate ID. Example being the Cmeds and Cmeddiagnosis. The reason I did that one is because some medications may be used for multiple...

Alright, I've got the new tables and relationships built. However, I definitely ran into a question on the relationships. Almost all of my relationships come from the contactlist table. Sometimes, that led to 2-3 relationships from contactlist to a table. Is that okay? It seemed kind of...

I really appreciate all the advice. I obviously was further off than what I thought originally. I decided to break my whole database back down and start from scratch. I figured that was easier than scrapping the relationships and fixing the table names. I will post that here in a bit when I...

Okay, I mainly need to update my look ups to be from the forms not from the tables. However, at that point to distinguish types do I just need to have a selection list in the table itself? Beyond that I need to rename tables. I also need to change my relationships to not involve the...

I can fix most of those issues pretty easy I think. The reason I had contact list and client information was due to another suggestion someone gave me before. I need more information on the clients than I do on the generic contact, so I made a separate table for it. Why would the look up...

Alright, so I'd just have them linked to the contact tab or even the cguardian/cdoctor tables? That makes sense, I think.

You just have to hit show all relationships. I hid them as I was going through them to help keep me on track. Once they were hidden I knew they were done as far as I knew how.

Sorry everyone, I thought I'd posted the database earlier, but apparently it was too large of a file without zipping. And yes, one client can have more than one guardian.

Hello all, I have been playing and tinkering with a database idea for my company for years now. I finally have had time to look at it a lot more here recently. I've set up my tables how I think they are needed. I've got relationships linking them all, I believe, accurately. The main...