AnsweredAssumed Answered

Value updates in relationship tables

Question asked by DanMatley on Feb 4, 2013
Latest reply on Feb 4, 2013 by philmodjunk

Title

Value updates in relationship tables

Post

     I have a Filemaker set up for managing job applicants. Applicants go in one table, and there's also a seperate table for Job Positions - the two are connected by a corresponding PostionID field in both tables. For instance:

         
  •           Table : Applicants           
                     
    •                     Field : Name
    •                
    •                     Field : Years of Experience
    •                
    •                     Field: PositionID
    •           
         
  •      
  •           Table : Job Positions           
                     
    •                     Field : PositionID
    •                
    •                     Field : Position
    •           
         

     In the Form View I have displayed the role each applicant is applying for by adding the field "Positions::position". HOWEVER, if I were to change this value to something else - ideally this would update the PositionID in the Applicants table for that applicant, but instead it changes the value associated with the PositionID in the Jobs Positions table.

     How can I correct this?

Outcomes