Skip to main content
Solved

Employee - Contact Person

  • February 24, 2021
  • 2 replies
  • 94 views

Forum|alt.badge.img+9

Hi,

On the pers_related view there is a column called Related_id, does anyone know if this field should be incremental or not as I am unable to work out the logic.

Thank you.

Nikki

Best answer by Sandun Madola

Hi @mlcscottonn ,

This is incremental.
(Related_Id gets the next value each time when inserting a new record. If the current value is 10, then the next value would be 11 or higher as how the sequence is defined.)

/Sandun M. 

This topic has been closed for replies.

2 replies

dhlelk
Superhero
Forum|alt.badge.img+15
  • Superhero
  • 200 replies
  • February 27, 2021

Hi @mlcscottonn,

It seems to be taken from the oracle sequence "RELATED_ID".

Cheers !
Dhananjaya.


Sandun Madola
Hero (Employee)
Forum|alt.badge.img+13
  • Hero (Employee)
  • 145 replies
  • Answer
  • March 2, 2021

Hi @mlcscottonn ,

This is incremental.
(Related_Id gets the next value each time when inserting a new record. If the current value is 10, then the next value would be 11 or higher as how the sequence is defined.)

/Sandun M.