Skip to main content
Solved

Employee - Contact Person

  • Feb 24, 2021 2:45 PM UTC
  • 2 replies
  • 102 views
Sidekick (Customer)
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. 

View original
This topic has been closed for replies.

2 replies

dhlelk
Superhero
Forum|alt.badge.img+15
  • dhlelk
  • Superhero
  • Feb 27, 2021 2:05 PM UTC

Hi @mlcscottonn,

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

Cheers !
Dhananjaya.

https://www.linkedin.com/in/kludl/
    Sandun Madola
    Hero (Employee)
    Forum|alt.badge.img+13
    • Sandun Madola
    • Hero (Employee)
    • Answer
    • Mar 2, 2021 7:53 AM UTC

    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. 

      Terms & ConditionsAccessibility statement