Ask Your Question
0

No Foreign Key Option

asked 2019-04-06 01:48:22 +0200

hetgoedeleven gravatar image

C:\fakepath\ClientIDNOFKonAddresstable.png

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 retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-04-06 16:51:13 +0200

nobody gravatar image

Unless I am mistaken, the foreign keys are not set up in tables. Define the relationships (one-to-one, one-to-many) between tables in Tools > Relationships.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-04-06 01:48:22 +0200

Seen: 117 times

Last updated: Apr 06