table relationships foreign keys

T_S_M
Tera Contributor

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