This is sort of a cross-post to an original problem of mine here: http://ift.tt/1Gz4an3
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 :) Thank you!
0 commentaires:
Enregistrer un commentaire