campanellisj
Registered User.
- Local time
- Today, 11:49
- Joined
- Apr 28, 2010
- Messages
- 23
Hello all,
I have a two tables that I am working with, (tblMCP) contains the actual positions in my unit and (tblBasicData) with the soldiers basic info (name, rank etc..)
What I would like to do is assign the position from tblMCP to the soldier filling the position in tblBasicData, then have that position be unavalible to be selected again.
I am not sure if this is even possible and I am open to any suggestion that can be given to achieve the same results
I have a two tables that I am working with, (tblMCP) contains the actual positions in my unit and (tblBasicData) with the soldiers basic info (name, rank etc..)
What I would like to do is assign the position from tblMCP to the soldier filling the position in tblBasicData, then have that position be unavalible to be selected again.
I am not sure if this is even possible and I am open to any suggestion that can be given to achieve the same results