AUTO NUMBER???

[Apprentice101]

I have a child (detail) block in tubular form. I need to have a field that will number the regults after the master is queried. ie.

MASTER = company
details= employees

details block looks like this:


NUMBER | NAME | LAST_NAME |ADDRESS
1
2
3
4

so I need that for every record on the detail block, a number is generated. So if a new employee gets inserted for this compay, the field "Number" created 5. by the same token if a company has 2, then the next time someone gets inserted they receive 3 ans so on.

can you guys please help me with this? I dont even know where to start.
thanks!

 

[BJCooperIT]

Can you use a sequence on PRE-INSERT that starts with your highest existing number plus one?

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus

 

[Apprentice101]

well, that would mean to have a sequence for each master record wouldnt ?

 

[BJCooperIT]

Yes, if you want each company to have employees with the same number. If that is the case your PRE-INSERT will have to query the detail table and find the max employee ID for that company and add one.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus