Hi everybody,
i started 4 weeks ago to teach myself ms access in order to create a db that will enable me to store the results of a survey. whilst working on the db creating tbls for locations, divisions, subdivisions, teams etc etc i became aware of the capabilities of this beauty.
not only was i going to be able to record my survey findings, nah, by following all tutorials patiently i might even be able to create a lovely front end enabling staff to participate in the survey over the network. i'm also in the process of using the db to track and trace all the paper records in our company.
however, working through my tutorials i now became aware of a few errors in the design of the db.
i originally set up the majority of relationships between the tbls by using the lookup wizard whilst creating a tbl.
because of my ignorance at the time i asked to link to the TopicName of existing tbls instead of TopicID. later when i came to understand that using the ID is better, i still reasoned that inputting data (which unfortunately is also done by me) is much easier when linked to the Name rather than some ID that i would have to look up all the time.
so here are my questions
is there a way to change the TopicNames automatically to TopicID instead of having to input all the data again? i did try to change it in 'edit relationship' in the relationships window, but the data stayed the same in my tbls.
i'm still not sure of how to create the forms to make it easier for me to input data? i wouldn't want to have to sit there, trying to have two tables open, looking up IDs all the time.
i hope i explained everything, sorry about the very basic question
thank you
dan
i started 4 weeks ago to teach myself ms access in order to create a db that will enable me to store the results of a survey. whilst working on the db creating tbls for locations, divisions, subdivisions, teams etc etc i became aware of the capabilities of this beauty.
not only was i going to be able to record my survey findings, nah, by following all tutorials patiently i might even be able to create a lovely front end enabling staff to participate in the survey over the network. i'm also in the process of using the db to track and trace all the paper records in our company.
however, working through my tutorials i now became aware of a few errors in the design of the db.
i originally set up the majority of relationships between the tbls by using the lookup wizard whilst creating a tbl.
because of my ignorance at the time i asked to link to the TopicName of existing tbls instead of TopicID. later when i came to understand that using the ID is better, i still reasoned that inputting data (which unfortunately is also done by me) is much easier when linked to the Name rather than some ID that i would have to look up all the time.
so here are my questions
is there a way to change the TopicNames automatically to TopicID instead of having to input all the data again? i did try to change it in 'edit relationship' in the relationships window, but the data stayed the same in my tbls.
i'm still not sure of how to create the forms to make it easier for me to input data? i wouldn't want to have to sit there, trying to have two tables open, looking up IDs all the time.
i hope i explained everything, sorry about the very basic question
thank you
dan