Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

simple PL/SQL question

Status
Not open for further replies.
Apprentice101

Apprentice101

IS-IT--Management
Aug 16, 2004
66
US
I have a form with a master-detail blocks.

I would like that as a new detail record is created, a sequential number is generated for that particular master record only

for instance.
master record
Jonh

details (brothers)
mary
Susan
Karla

so I want to have a column next to the detail names that will have the values 1,2,3 respectevly. And as a new name gets inserted, (Claudia) a number 4 will be generated.

This numeric value should only affect John, so if Douglas (another master record) gets interted, the value should be 1 again for row one on the details section.

so how do I do this?
thanks!!
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
1K
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
Question re: SELECT DISTINCT 1
Replies
6
Views
1K
SkipVought
S
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
6K
carp
carp
rk68
  • Locked
  • Question
Data fetch issue thru PL/SQL developer
Replies
4
Views
380
rk68
rk68
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
485
carp
carp

Part and Inventory Search

Sponsor

Back
Top