frecapi (2/14/2011)
There can only be a maximum of 8 permits per record. There can be more than 8 records per APN in which case the permitnum would equal permit_8 + '_9' for row 9, permit_8 + '_10' for row 10 and so on...
Sorry... looking back, I see you included that in the original post.
Have you considered normalizing the table so that you only have one permit per row?
--Jeff Moden
Change is inevitable... Change for the better is not.