So I need a one to many correct me if I’m wrong. I have clients with multiple addresses, example. Mr.SmithProperties needs its own unique ID or Client ID ------> to multiple(many) addresses. I would link these tables in a relationship. Each Client might have just one address as well, but could have many addresses under one client ID. So on the address table there is a foreign key of client ID. that allow the one to many relationship to occur. I though cannot find where to add a foreign key on the address table to make this relationship happen in libre base.
(Edit: activated screenshot -AK)