hello
Forgive my ignorance - this will be more embarrassing for me than for you!
I am trying to create a database to hold the training records of our staff.
I have a staff table, linked from our main staff database, a course details table, an attendance details table and a course request table.
I think I'd like to use a look up for the staff and course details in the request and the attendance table, with the hope of eliminating rubbish data.
I also thought that I could create a form, possibly an access data sheet that I could put on our intranet so that users can request training online, so the drop down list created in a combo box from the lookups seemed like a good idea.
When I go to create the lookup I choose the table I want and the field I want, and give it a meaningful name. I keep getting a message telling me that I already have a field called ID, and the data format of the pertinent field always seems to be a number.
My guess (and it is only that) is that it's something to do with the ID/autonumber thingy...
Please could anyone tell me how to set this up, and whether I should be doing it this way anyway!
I'm sorry about my lack of knowledge, I fear training doesn't come high up our list of priorities here...
Many thanks for any help
lynne
Forgive my ignorance - this will be more embarrassing for me than for you!
I am trying to create a database to hold the training records of our staff.
I have a staff table, linked from our main staff database, a course details table, an attendance details table and a course request table.
I think I'd like to use a look up for the staff and course details in the request and the attendance table, with the hope of eliminating rubbish data.
I also thought that I could create a form, possibly an access data sheet that I could put on our intranet so that users can request training online, so the drop down list created in a combo box from the lookups seemed like a good idea.
When I go to create the lookup I choose the table I want and the field I want, and give it a meaningful name. I keep getting a message telling me that I already have a field called ID, and the data format of the pertinent field always seems to be a number.
My guess (and it is only that) is that it's something to do with the ID/autonumber thingy...
Please could anyone tell me how to set this up, and whether I should be doing it this way anyway!
I'm sorry about my lack of knowledge, I fear training doesn't come high up our list of priorities here...
Many thanks for any help
lynne
