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!
Page 1 / 1
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.