table relationships foreign keys
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-07-2024 06:48 AM
Very simple question.
Just took the self paced development class.
I want to rewrite an Oracle APEX app in Service Now. So baby steps.
1) I created two tables and loaded them
container
server
2) server points to container with column container_id (PK)
container has a one to many relationship with server
3) What I tried
- I created a reference column in server table. it references the container table
reference spec doesn't really have anything to specify a column/relationship
I want to see the container column from the container table
- I created a relationship
applies to table: server
queries table : container
(function refineQuery(current, parent) {
// Add your code here, such as current.addQuery(field, value);
parent.addQuery('container_id','=',current.container_id);
})(current, parent);
0 REPLIES 0