Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
No problem.
Make a new table called Max Record ID of Widgets (or whatever is it you are tracking). Add 1 Record to that table, even with no fields. It will be Record ID #1.
On hour widgets table make a formula numeric field called [Link to Max Records]
with a formula of 1. It will not surprisingly calculate to be 1.
Make a relationships where 1 Max Record ID has Many Widgets and use that formula field [Link to Max Records] as the reference field on the right hand side of the relationship.
Use that relationship to make a Make a Summary of the Maximum Record ID# and look that up own to the Widgets. Now every Widget record knows the Max Record ID. Note that you may need to add 1 to it depending on when the user pushes the button compared to when the record the user was on when the copy was made refreshes.
Make a new table called Max Record ID of Widgets (or whatever is it you are tracking). Add 1 Record to that table, even with no fields. It will be Record ID #1.
On hour widgets table make a formula numeric field called [Link to Max Records]
with a formula of 1. It will not surprisingly calculate to be 1.
Make a relationships where 1 Max Record ID has Many Widgets and use that formula field [Link to Max Records] as the reference field on the right hand side of the relationship.
Use that relationship to make a Make a Summary of the Maximum Record ID# and look that up own to the Widgets. Now every Widget record knows the Max Record ID. Note that you may need to add 1 to it depending on when the user pushes the button compared to when the record the user was on when the copy was made refreshes.