I have a main form which has Job details on and a subform which lists Media details. What I want to achieve is if I entered a job number of 2000 that the media number on the sub form is assigned 1 if no other media is assigned to that job or is incremented by 1 if other media exist. This rule should apply to all job numbers. What Im trying to get is the following:
Enter Job Number 2000 Media Number = 1
Enter Job Number 2001 Media Number = 1
Enter Job Number 2000 Media Number = 2 etc
I may be approaching this the wrong way but look forward to anyones comments.
Thanks
Woody Woody
Enter Job Number 2000 Media Number = 1
Enter Job Number 2001 Media Number = 1
Enter Job Number 2000 Media Number = 2 etc
I may be approaching this the wrong way but look forward to anyones comments.
Thanks
Woody Woody