Relationships and data import

[FlodAriege]

Hi!
I’m brand new on Budibase and, until now, got help only from Gemini (which was not very effective lastly since it kept apologizing for giving me wrong explanation based on a “different version” of Budibase, not the Docker self-hosted one).
My ultimate objective is to turn all my Excel system into a web application (contacts database, articles database, quotations, and plenty of docs filled with data from the quotations and the databases).
But, for now, I’m still at the very beginning.

Where I am:
With the help of Gemini, I managed to install Budibase on my NAS with Docker, to create a Table of my contacts based on the architecture of my Excel contacts list, to create 2 forms (one for create, one for edit the contacts).
I imported a dozen of lines of my 4000 lines contacts list. And I have imported a table of cities, with their zip code.
That’s it for the context.

Now, my problem:
I can’t get to import the cities of my 4000 contacts since the column in my table Contacts is a Relationship one.

I managed to make the city field of my forms a relationship with the Table Cities. But I did so by creating- on Gemini’s advice- a second column for cities (named cities_rel).
This seems messy and when I try to import my 4000 contacts, of course the cities goes in the Text column named cities, not in the Relationship column named cities_rel.

How should I process to get things cleanly done?

🙏 Thank you for your help. Please remember that I am a total newbie.👶