Forum Discussion

Qrew Cadet

8 years ago

How to show the last ""note"" record in a report

I have two tables, a project record table and a notes table. The notes table has a table to table relationship to the project record table. What I'm attempting to accomplish is to have a field in t...

Ask about Quickbase functionality

Relationships

Tables and fields

ChuckGrigsby

Qrew Cadet

8 years ago

I think you may need to create a summary field of the Maximum Record ID of the notes table.

QuickBaseCoachD

Qrew Captain

8 years ago

No problem. Go to the relationship where 1 Project has many Notes and there will be a button on the left side of the Relationship to Add Summary field.

Forum Discussion

How to show the last ""note"" record in a report

Related Content

Can a "Notes" field expand without changing the form?

Using Grid Edit to Edit Multiple Records at Once

I imported a file with a note field. It brought in text with a number of """" in the text field.

Record Details

Summary Reports