Dec 18, 2012; 22:25
Ed Bullock
[FMPro] Portal for records not yet related
Hi all
I am sure this is straight forward but 14 hours straight on this database is
frying my brain!
I have 3 tables
Jobs
Candidates
Submissions
When a candidate is submitted for a job, a record is created in the
submissions table.
This record includes the JobID and the CandidateID
Jobs table is related to Submissions by JobID
Candidates table is related to Submissions by CandidateID
When in the jobs table I'd like to display a portal listing all candidates
who have NOT been submitted to the job.
Obviously it's very easy to display a portal of who has been submitted, but
how do you do the reverse?
Many thanks
Ed
#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>
Dec 19, 2012; 07:19
Brian Beer
Re: [FMPro] Portal for records not yet related