Best way to track project status and tasks


Hello. I have a table containing all my projects (proj #, client name, etc.) and another table where I periodically add project status updates and new tasks, using a form. How (and in which table) can I create a view that shows me all my open projects, and the latest status update and/or task, using information from both tables? Thank you!


You could have a View in the Projects table to Filter projects by status (you have a Status field?). You could bring the latest Status Update with a Rollup field and the MAX() field type to the Status Date.