Foreign Keys and Structure

[795619]

Hi I'm new to ServiceNow and today I'm trying to create tables in the Berlin version. I'd like to use ServiceNow tables to store my structure as well as data. I've used regular MySQL tables in the past, but here (in the Berlin version), I can't find any way to connect tables using foreign keys. For example, there will be a number of posts in the content . So the posts table will need to have a key to the content table to define which posts go to which contents. So my questions are:

1. How do I set up foreign keys in tables please (in ServiceNow Berlin)?
2. What would be the best way to achieve my goal, that is, to connect several tables (but keep them separate) for my project (for example, the main table called content has children like form, list, navigation etc.)?

I'll appreciate any help.

[Community Alums]

Jakub, sorry for not including this information originally. I usually reference tables that already have a display value assigned. To configure your reference field to display the information from your custom table, use the information in this wiki article: Reference Fields - ServiceNow Wiki about Display Values.

[795619]

Thanks Ben. Even though I check the Display box on the attribute I want to use when referencing tables, it doesn't show up in the popup window. There's the sys_id instead. I also made sure there was only one attribute with the Display box checked. I still can't see it. This is what the popup window looks like after clicking in a referenced input box:

       

[Community Alums]

DEVEL instance? I love it!

Here you are just working with a basic Sys Admin capability. Right-click the column header and select Personalize > List Layout. Then you can select the columns you would like to have displayed when you click the magnifying glass.

[795619]

Thanks Ben, although this didn't solve the problem

[Community Alums]

What happened when you tried to change it this way? We chould try to set up a screen share to look together if you want...