Recent content by davidfourie

Mike, the records are stored on paper in departmental folders. When i search the database for an employee it must give me the department they are in and their record number so I can go to the correct file and get out their record. I am still don't understand the problem. With the set up. A...

yes please. Please can someone explain how I would do this. That sounds like it is the answer.

Thank you SOS for your increadably insulting and complicated post. Let me answer you critism in a polite but firm fasion: 1. this is increadably insulting. Yes I would say I am a bit rusty but to quote my self: I said in the post that splitting the employees into seperate tables...

Not sure this works for me. the employees details are stored on a paper based system. They are put into files depending on their department (HR, ADMIN, ACCOUNTS) and ordered in chronological order by when they start. hence the ADMIN 1, ADMIN 2 etc. if it was on different tables i would...

In a table I have several different departments. Depending on the department I would like to have seperate autonumbers. The tables primary key will be a combined primary key Department and ID table = people[Department,ID,Name] So the data would be something like: Accounts, 1, Sally...