Recent content by jontait

Pat, I was pointed to your example MANY-TO-MANY by MikeFabro on here...THANK YOU SO MUCH, its just what I needed to sort my disaster of a database out. I can feel my blood pressure slowly returning to normal, god knows when the hair will grow back though! Thanks muchly

Hi Mike I've done it!! I've finally got the database I was after. Thank you! I'm having some trouble however sending the bottle of beer. I've contacted our IT guys but they assure me thats not what my network hub is for?!? Cheers

Mike The clouds are beginning to clear now and it's all starting to make sense :) Thank you so much for your help, I'll magic a bottle of cold beer to your desk as we speak, you might need to increase your bandwidth to accomodate it though! I'll have a look through the database that Pat...

Thanks Mike Thanks Mike...this forum is a gold mine! I've created the links etc as you've said, I've attached the new relationship table, have I done it right? I'd now like to be able to set up a form whereby the user is presented with a form to browse/enter employee details and within that...

Len Thanks very much for your help, I've made the changes you suggested. However, What do you eman by primary and foreign key? I can make just one field a primary key within the tabel, how do I make both primary and how do I make a field a foreign key?.....sorry but I REALLY am a beginner...

Hi, I'm very much a beginner with Access 97 so please be patient! I'm creating a database to show skills, knowledge and training of employees. I've got two tables, one called EMPLOYEES and the COURSES. The fields are as follows: EMPLOYEES EmployeeID Name Telephone JobTitle COURSES CourseID...