Hi all, been scratching my head for hours on this one and finally will bow to someone with more brains than me!

I have a main ISODEP_JobDetails table which includes the following columns:
Job_JobNumber
Job_UniqueKey

I have two other tables that link to this main table
ISODEP_HAJobNotes (Fields are Notes, JobUniqueKey)
ISODEP_HAExtraChg (Fields are Quantity, JobUniqueKey)

I would like to pull in the Job_JobNumber field from the ISODEP_JobDetails table and the Notes and Quantity fields from the other 2 tables (If their JobUniqueKeys=ISODEP_JobDetails.Job_UniqueKey)

This is my attempt but it just gives me unhelpful errors. Thanks in advance for any assistance

Please Login or Register  to view this content.
Thanks
John