Adding custom profile field with foreign key to custom table

Hello,
I've created a table in my database called Offices, it's got the office ID , Name and location details
Now, I want to create a relation between one type of users ("OfficeStaffProfile") to the office.
I've seen that i can create custom profile fields (of basic types), but how can i create a foreign key field? so i could choose from the list of given offices?

Thanks,
Or.

Hi Or,

Unfortunately we don't provide such functionality out of the box, there are different approaches that you could achieve this - one is to have your one fieldcontrol that reads the data and you store in your item just the selected id or IDs. This I think would be the easiest approach.


Greetings,
Pavel
the Telerik team