Home / QIN / fill

fill

Syndicate content
More
How can I automatically populate many pieces of user information into Project records each time a user adds a Project?

You will need (at least) two related data tables to achieve this result.
Assume that you already have a table called Projects with a User field called 'Assigned To'.

February 5th, 2009 - 6:02 PM
2 comments
Tags:
More
If I have a Projects table and a Tasks table where each Project record has many Task records how do I automatically indicate that the Project is completed when the "Status" field in all the related tasks are marked "Completed"?

Create two summary fields in the Projects table. The first summary field will be labled "Number of Tasks". It should be configured to count the number of Tasks. The second summary field should be labeled "Number of Completed Tasks". It should be configured to also count the number of related Tasks with a condition to include only the Task records where the "Status" field is "Completed".

February 5th, 2009 - 6:02 PM
2 comments
Tags:

© 1997-2013 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit