P
pompeyboyUSA
To be honest I am not sure if this is possible, I have a plan that I want to
produce, but cannot seem to get it to work.
Here goes....
I work for the Military (so apologies if I don't go into too much detail)
and I want to produce a database of manpower for a unit 500 strong - fairly
low key stuff. Each position has a unique number and a Position ID assigned
to it - each person has a unique service number and personal details. There
should only be one person in each of the positions at any one time. People
do come and go, and change positions with promotions/postings etc. I would
like to be able to choose a position, and assign a person into that position
at the click of a mouse (without having to go into the table and cut and
paste) - the idea being auto filling details. I hope that makes sense! I
have built databases before, and would class myself as intermediate. Any
help in the right direction would be very much appreciated.
produce, but cannot seem to get it to work.
Here goes....
I work for the Military (so apologies if I don't go into too much detail)
and I want to produce a database of manpower for a unit 500 strong - fairly
low key stuff. Each position has a unique number and a Position ID assigned
to it - each person has a unique service number and personal details. There
should only be one person in each of the positions at any one time. People
do come and go, and change positions with promotions/postings etc. I would
like to be able to choose a position, and assign a person into that position
at the click of a mouse (without having to go into the table and cut and
paste) - the idea being auto filling details. I hope that makes sense! I
have built databases before, and would class myself as intermediate. Any
help in the right direction would be very much appreciated.