Recent content by rjhartman

I solved this myself. I did away with the sub-sub relationship and just made it into a subtable. Taught me the value of KISS. Richard

Hi, I wish to create an append query to duplicate a record and it's related records in two other tables which creates a sub-sub relationship. Tables are: OrderDetails --> Invoice --> Rates Related Keys are: OrderID JobID ItemNo The OrderDetails table has a one to many relationship with...

I now want to try and extend this query. I want to find out which key certificates each employee doesn't have. I think this is far more difficult. I have tried a few things out. The only thing I can think of is to write a function in vba which compares each employee's certificates with the...

Thanks Cowboy, That worked. it has flagged up the correct employees. So thanks for helping out!!

querying two fields in two tables using a conditional statement? Hi Can someone help me solve my access woes. I want to query the values in a table with the values in the field of another table but... i need to loop through the records in the second table using another field. For example...

Thanks Cowboy but that's an unmatched query which i have already tried. I will try your suggestion. Richard

Hi Can someone help me solve my access woes. I want to query the values in a table with the values in the field of another table but... i need to loop through the records in the second table using another field. For example, KEY_CERTIFICATES (table1) contains a field called CertificateID...