Add duplicate field to same table

[garyGHL]

Hello, I want to try and capture referrals from exiting clients, has anyone done this in Noloco?

I have a clients table, where we can add new clients. If a new client was referred to us by an existing client I want to tag them, so in effect the client table will have a field for client name and a new field for referred by. What I cant seem to do is to have this referral field as a select field showing all exiting clients to choose from.

I tried lookup but that I think wont work inside its own table, has anyone any ideas if this is even possible?

[SamEdwardsRVA]

You should be able to do a linked record column to the same table, if that doesn’t fit your use case I would do a join table - but this is what i just quickly came up with in a sample template