Hello,
I think that this is a bug… details below:
I would like to create a relationship (via an automatic link) between two Noloco tables:
Table 1 = Contact Numbers – contains Telephone numbers (primary key, text format) and corresponding contact details.
Table 2 = Call Log – which contains Telephone call logs. There is a ‘number key’ (text field) which is the telephone number. This matches the telephone number primary key in the Contact Numbers table.
It’s a one-to-many relationship - there will be many calls in the Call Log table for each contact number in the Contact Numbers table.
The issue:
In the Call Log table, I add a relationship column, select the Contact Numbers table, but at this point, the Choose a field type changes to Phone Number. I’ve attached a screenshot that might help.