Do you have any budget to book time on one time with me to get this working? That would be faster.
Thanks for the quick and detailed reply. np
I get the idea behind the project months table, but I'm not clear on why the focus project table is needed.
The focus record is needed to temporarily record the Focus Project for a split second.
Couldn't the same lookups be passed down to the project months table directly from the projects table?
You still need a way to create the Project months children records and they need to each know what month they represent.
I'm also not clear what the delete automation is doing - are you saying it's deleting unused template records in the project months table?
Suppose a project has 5 children because it's a 5 month project. Then the user adjusts the dates and makes it a 10 month project starting a year later. Th easiest way to deal with edits is just to start with a clean slate, delete all the children for that project focus project and import in a new set for the 10 months.
And then calling a saved table to table import to copy records from the project months table to ... where? The focus project table? The records are being copied from the 1,000 record table into the Project Months child table, but just as many of hem as we need of the "1,000".------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
