Makes sense. Initially was trying to avoid this thinking there was less ‘computed column gymnastics’ required. Will take a few steps back to go forward with a simpler solve
My solution is only if you don’t want to touch your initial table
having a play with this and getting stuck…i have a form that the user inputs other project details into. Can they input this info in ‘Projects’ table and then the dates into ‘Project Milestones’ table all from the same form?
If this requires a 2nd form then i may need to limber up and try some gymnastics
To keep things clean, I would probably do it separately.
On the Project details screen, have something like an “Add Milestones” button. This would open a separate form that targets the Project Milestones table and prompts for Milestone name, Start Date and End date. Then pass the ProjectID as a column value with the form.
1 Like
Thanks. I prefer the look of not having another button to add these dates but i think i can use this idea for some other additions like adding project tasks and expenses.
Thankyou very much for the feedback and guidance. I feel like a genius when i can make this stuff come together!
1 Like
This looks to be working fantastically. Thankyou so much for your help
1 Like
My pleasure!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.