Search results

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...

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...