yellowcake Posted May 22, 2009 Share Posted May 22, 2009 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 Link to comment Share on other sites More sharing options...
yellowcake Posted May 22, 2009 Author Share Posted May 22, 2009 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5452 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now