Search results

Ok, so I've been spending all my scant free time reading up on normalization, making things atomic, and such. I totally get the whole normalization thing now - and I have to say it is pretty cool! I've been building the "back end" of the database, including such things as departments...

Great! I was able to use the Eagar-derived file to create a working DB that seems to perform the needed functions. After reading over all the posts more closely, it would appear that both Eagar's and Doc_Man's approaches are very similar: one table that contains all items, and a separate...

2007 ...but I'm aware that there are some PC's on our network that are running 2003 (I'm trying to keep in mind the issues there...due to chemical analysis software limitations I can't upgrade the older PC's just yet)

Eagar - Could you be a little more specific on how the "Bill of Materials" table is set up and related to the Item Table? Doc_Man - thanks! I am going to have to take some time to digest this info. This seems like a complete long term solution.

Thank you for the rapid reply, and may you stay above water! Your ink situation does sound quite similar. So, perhaps my error is in creating a separate table in the first place? If everything simply resided in one table, then I would be able to pull the appropriately flagged/categorized data...

I know, I know...chemistry. *yawn*. But, can you help a chemist out? Here's the situation: I work in a chemistry lab in which I routinely make up drug standards and reagents that are diluted, mixed, combined, and used in various procedures. I have been tasked with making an Access database in...