Can I refer to a field inside the same table?

[BP6]

Weird question but can I create a Reference field that refers to another Field within the same table?

[Filipe Cruz · Accepted solution]

Hello BP,

Sure!
That is done, for example, in the incident table, where the Parent field is a reference to the incident table.
Same happens in groups: A group record has a reference to the group table.

So what you are asking is perfectly normal!

Hope my answer clarifies your question!

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz

[BP6]

Filipe, can you tell me how I would set that up then?

I create all my Tables using the Studio. I know that when creating a reference field, I have to choose "Reference" under field type and then select the table of interest under "Reference".

What other steps would I have to take to create this reference then? The Field/Column labels will of course be different. So using your example, how would I setup the reference between 'Number' and 'Parent Incident'?

[Filipe Cruz]

Hi BP,

You simply create a new Reference field and, in this example, select the "Incident" table as the reference table.

The field that appears in the reference field is always the table field marked as "Display":

Does this answer your question?

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz

[BP6]

Whoa! That answers so many questions. So I should always have only one Display field per table then, and that should be my unique/primary identifier. 

Thank you so much!!!!