Correction - Counting the number of items that have a flag set.

Apologies for the second post. I had a confusing typo. Good afternoon; I'm trying to learn how to count the number of entries with a particular status set. 1. I have two tables: JOBS and TASKS. 2.…

Counting the number of

Good afternoon; I'm trying to learn how to count the number of entries with a particular status set. 1. I have two tables: JOBS and TASKS. 2. Each entry in JOBS can have multiple TASKS assigned to it,…

How to associate multiple records in one table with a record in another table

Hello. Due to changes in workflow I have a new table (B) that I need to associate with a table (A). Is there a way to associate multiple entries in A with a particular entry in B? That is,…

• Answered