AnsweredAssumed Answered

How to create records in one table using another?

Question asked by RonaldCarr on Apr 16, 2013
Latest reply on Apr 16, 2013 by philmodjunk


How to create records in one table using another?


     I am writing an application for a Job Bank.
     I have the following tables:
     Jobseeker        PKContactID
     Jobseeker Skills    FKContactID and FKSkillID
     Open Jobs        PKJobID
     Open Jobs Skills Needed    PKJobID and FKSkillID
     Referrals (A list of Jobseekers with matching skills

     for a Job)

     I have the relations set up so that when I display a
     specific Open Job, there are two portals, once which
     shows the related Open Jobs Skills Needed, and the
     other Jobseekers with skills that match.

     I can then flag specific Jobseekers with the job

     Problem: I then want to create Referral records for

     each Jobseeker/Job combination.
     I am assuming a button on the Job layout which will
     run a script to create these records: this would be
     used immediately after selecting specific Jobseekers:

     there would be records created only for the Jobseekers
     that are selected for one single job.

     I do not see how I will access the Jobseeker records
     that have been flagged and create a Referral record
     for each one.

     If I Find matching records in a Jobseeker layout, the
     add a record to referrals, then the focus is now on a
     Referral record and I have lost the ability to cycle
     thru the Jobseeker records.

     I hope this is clear...

     Thanks for any thoughts.