Recent content by midastouch1

Ok, so after a couple of phone calls between Frothingslosh and I, he beat me upside the head with the simple solution: normalize your data retard... What I had was parent table "a" with child table "b", but child table "b" needs a child table "c" to define the subparts associated with the...

Frothing, Thanks for the suggestion. I think I'm missing something here. I fully understand that I broke the hell out of normalization when I basically stuffed a 4-field table into the middle of an existing record (6 if I made a separate table and added PK and FK fields). Yes, there are actually...

I work on a medical research team, and we get whole specimens donated to us. When we receive these specimens, we slice them up into (up to) 35 pieces (and are tracked as 35 unique fields in the associated table). Then each piece may or may not contain certain "parts" of the whole. The parts of...

So....new to Access here, but experienced in SQL. I work on a medical research team and have a database that contains a table for patient demographic info (name/age/SSN/race/etc) and a table for autopsy information (time/cause of death, etc). The PK for the demographic table is a random...

Plog, while I appreciate your diligence in researching the requirements I posted, I'd prefer not to debate the merits of requirements passed down to me by my organization's Institutional Review Board (IRB) and by the Primary Investigator (PI) for the supported research project. Regardless of...

I've seen a couple of posts on here related to this. I am in a similar situation as some of the other folks on here. I need to restrict the random autonumber feature to 10 digits and a positive number for a primary key. I work in the medical field, and HIPAA privacy regulations require the use...