This is sort of a cross-post to an original problem of mine here: http://www.access-programmers.co.uk/forums/showthread.php?t=276943
plog was helpful and showed me what was going wrong in the database but I am unsure of how to really correct that (and I don't like to pester anyone with question after question and figured it be best answered under the Tables forum). plog has informed me that my form is based on a query and not a table like I had originally thought. My main question is how can I correct my tables so I can re-structure my form correctly?
Attached is an image of the relationships I have set up for the database.The main table I use is tblSample. As you can see, all other tables are linked to this in a one to many relationship. Is this the proper way of doing this? I have tried to normalize everything out but am unsure if it has been done properly (probably not seeing as I have come across several problems). Furthermore, I've been using look-up fields for the following: SampleTyp, Products, Requester, Classification, Panelists, Contact_Info... so about everything. Can any of you please point me to a better procedure to structure this properly? I've been going through MS Access 2013 for Dummies and the Access Bible but it's been slow progress. I know the learning curve is steep at first but I'm starting to get some aspects of it.
Any advice is greatly appreciated
Thank you!
plog was helpful and showed me what was going wrong in the database but I am unsure of how to really correct that (and I don't like to pester anyone with question after question and figured it be best answered under the Tables forum). plog has informed me that my form is based on a query and not a table like I had originally thought. My main question is how can I correct my tables so I can re-structure my form correctly?
Attached is an image of the relationships I have set up for the database.The main table I use is tblSample. As you can see, all other tables are linked to this in a one to many relationship. Is this the proper way of doing this? I have tried to normalize everything out but am unsure if it has been done properly (probably not seeing as I have come across several problems). Furthermore, I've been using look-up fields for the following: SampleTyp, Products, Requester, Classification, Panelists, Contact_Info... so about everything. Can any of you please point me to a better procedure to structure this properly? I've been going through MS Access 2013 for Dummies and the Access Bible but it's been slow progress. I know the learning curve is steep at first but I'm starting to get some aspects of it.
Any advice is greatly appreciated
