I am requesting any ideas/suggestions/advice/guidance on a user interface form dealing with a 1 to 1 relationship.
Here’s the situation – I have three tables: tblRecruitRacks (RackID, Position, CleaningStation); tblRacksAssigned (RackID, RecruitID); tblRecruit (RecruitID, etc…).
tblRecruitRacks is 1-1 with tblRacksAssigned which is 1-1 with tblRecruits. (tblRacksAssigned is required because the data in tblRecruitRacks is permanent and has already been entered. The data in tblRecruit gets deleted at the end of training which would delete the data in tblRacksAssigned but would leave tblRecruitRacks intact.)
I am trying to create an easy and efficient form that would allow the user to assign a rack (“rack” in Sailor speak is “bed”) to a recruit. Only one recruit can be assigned to a rack. The rack numbers and recruit names are already in the database. Sometimes a user has to move a recruit from one rack to another. (For this I created a “fake” rack in tblRecruitRacks in order to temporarily move a recruit.) I would like to be able to assign racks/recruits by just clicking or double-clicking the existing data to tie the two together.
I appreciate any guidance offered.
