Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoNo, it's not going to work like you have wanted.
You will need to make a relationship where 1 Plan is related to itself, ie the table related to itself.
Quick Base will ask you if you are sure and then go ahead.
Call the reference field that is created [Related Last Year Plan].
Then lookup any fields you need from last year to this year. You will need to edit every Plan to relate them to Last year. Not sure if this is dozens of records or hundreds or thousands.
If the numbers make this manual approach impossible, then there could be a Plan B which would involve changing the Key field of the Plan table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You will need to make a relationship where 1 Plan is related to itself, ie the table related to itself.
Quick Base will ask you if you are sure and then go ahead.
Call the reference field that is created [Related Last Year Plan].
Then lookup any fields you need from last year to this year. You will need to edit every Plan to relate them to Last year. Not sure if this is dozens of records or hundreds or thousands.
If the numbers make this manual approach impossible, then there could be a Plan B which would involve changing the Key field of the Plan table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JenniMurray6 years agoQrew CadetHi Mark,
Thank you for your reply!
I'll see if your Plan A will work. This is a new build, so not many records will need to be updated.
Thank you :)
------------------------------
Jenni Murray
Detroit, MI
------------------------------