Display field of most recent child record?
Parent table: Computers I want a field in this table to reflect the most recent "status" that was entered for each child record in a Statuses table. I'm sorry -- I'm sure this has been answered som...
Forum Discussion
Make a summary field of the maximum of the Record ID# of the child status table records called [Maximum Record ID# of status records]
Make a new relationship where 1 Status is related to Many parents - ie a reverse relationship and the reference field at the right side will be that field [Maximum Record ID# of status records]
Then just do a lookup of the Status from the Child to the Parent. but QuickBase will see it as a lookup from a parent to a child.
Make a new relationship where 1 Status is related to Many parents - ie a reverse relationship and the reference field at the right side will be that field [Maximum Record ID# of status records]
Then just do a lookup of the Status from the Child to the Parent. but QuickBase will see it as a lookup from a parent to a child.
Hi!
My apologies for the very naive question but how/what is the syntax to get the maximum record ID#?
I created a field and typed ' Max([CI-PN ID#]) ' under the formula field but the syntax seems to be incorrect.
How do I get a max of a record?
And more generally how can I get the max of a table or a column of a table?
Thanks for your help
My apologies for the very naive question but how/what is the syntax to get the maximum record ID#?
I created a field and typed ' Max([CI-PN ID#]) ' under the formula field but the syntax seems to be incorrect.
How do I get a max of a record?
And more generally how can I get the max of a table or a column of a table?
Thanks for your help