counting entries in a related table

[yellowcake]

Hi Guys, i'll try to explain the question. I have a main table (this table contains the info about the job). I have a revisions table thats related to that job number - and i want to assign a revisions number to each entry - expect that when a new record is taken out on the main table - i need the revision to be reset back to 0.

IE.. job number 123 (main) has (revisions) 1, 2, 3

Job number 124 (main) has (revision) 1, 2

Job number 125 (main) has (revision) 1, 2,3,4,5

hope that makes sense

Cheers

AL

and so on.

Im sure that thsi is a very easy thing to do, but im stuck on it.. any help would be very much appreciated

Cheers

Al

[yellowcake]

heh .. solved it after looking for complicated calculations... it was as simple as putting @@ in the row portal!

There you go.. sometime the solution is right in front of you but you cant see it for looking hey!

Cheers

Al