Document Tracker

[dmkeith2]

I'm in the military and creating a database to track awards. I need to

create a document register where the award can be tracked if it were to

leave the office and go back to the recommender for corrections or come

back.
Basic Lay out would be
Main Form: Name, SSN, Recommended Award, Company
Subform: Date Received, reason received, Date Out
Problem is when I have to enter an award for the same person but for
different circumstances, the subform will show the same data on both
awards. I need it to be separate.
Thanks

[pietlinden]

sounds like you need to differentiate the awards.

Person--(1,M)---WinsAward---(M,1)---Award

WinsAward--(1,M)--AwardMovement (Subform)

WinsAward would have its own unique ID (maybe an autonumber) and then
you could link that field to "AwardMovement" or whatever - the
individual award/documentation being shipped back and forth. And the
last record should be the current location of the award.

[dmkeith2]

In the military we use SSN's I know this is an issue with some, but
this is how Soldiers are tracked due to the number we have.

My solution was to create an AwardsID on my main and subform. I then
indexed it and allowed duplicates. I did the same thing with the SSN.
Now when I add an aditional award on a Soldier the subform duplicates
the AwardID on the main and subform allowing it to be separated from
the first award submitted.

So everytime I click on a different award for a Soldier I see only the
history of that award, thus creating and effective document tracker.

Thanks