Create Numeric Identifier on Child Record
I'm trying to number specific child records based on the parent record. So for example, parent record has a record ID # 10. I add 3 child records. I'd like to number those child records 1, 2, 3 w...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf you can ensure that you will never delete child records, then you can
Make a summary field of the # of Child records.
Look that up down to Children and call it [# of children (lookup)].
Then make a new field called SEQ and set it to be a snapshot field of [# of children (lookup)].
Note that this technique will only work on a going forward basis. It will not sequence existing records.
If you have knowledge that there will only ever be a small number of children, say under 10, then there could be another technique I can explain which will work for existing records.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------
Make a summary field of the # of Child records.
Look that up down to Children and call it [# of children (lookup)].
Then make a new field called SEQ and set it to be a snapshot field of [# of children (lookup)].
Note that this technique will only work on a going forward basis. It will not sequence existing records.
If you have knowledge that there will only ever be a small number of children, say under 10, then there could be another technique I can explain which will work for existing records.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------
Thanks Mark. There should only every be small numbers of child records (under 10) so if you could share a technique for existing records that would be great.
Thanks
------------------------------
Sheila Allas
------------------------------
Thanks
------------------------------
Sheila Allas
------------------------------