Preventing duplicate record assignments

[ppoindexter]

I have a form that allows users to select a soldier from a combo box which assigns him/her to a specific mission...currently the user can assign any soldier to a specific mission numerous times..I need to prevent this from occuring....each soldier should only be able to be assigned to any mission one time....
Thanks in advance
Pat

 

[GordonR]

Fogive me if I am missing the point, but as a new member I feel morally obliged to try to answer instead of asking!!
If you are populating a 'mission' table, then indexing with no dupliactes the soldier field would prevent it. If the table is status sensitive (eg holds open and closed missions with a status to indicate this) then include the status field to form a multiple field key.

 

[SforSoftware]

Hi,

In your mission-table, put the Primary Key on the fields MissionID and SoldierID together

Succes,
Bert

 

[ppoindexter]

Thank you both for replying...

I am populating tbl_main with this form, population of this tbl consists of mission_id, soldier_id as well as several others...any other ideas???