Solved

Employee - Contact Person

  • 24 February 2021
  • 2 replies
  • 85 views

Userlevel 4
Badge +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

icon

Best answer by Sandun Madola 2 March 2021, 08:53

View original

This topic has been closed for comments

2 replies

Userlevel 6
Badge +15

Hi @mlcscottonn,

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

Cheers !
Dhananjaya.

Userlevel 6
Badge +13

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.