Effectively a sort of Sub-Summary Serial# applicable to IWP
Posted on 2011-02-28
In my database I have a table named "Property" which contains a field named "PropID" which is a autoenter serial number which will apply a unique identifier to each specific record.
Each record contains the field "Lands" which is not a unique field among the remaining records. I am interested in finding a way to create a sort of "sub-summary" serial id according to the groupings of "Lands" records.
For example, if I have the following records:
Serial# Description Sub-Summary Serial#
PropID01 LandsA LandsA1
PropID02 LandsA LandsA2
PropID03 LandsA LandsA3
PropID04 LandsA LandsA4
PropID05 LandsB LandsB1
PropID06 LandsB LandsB2
PropID07 LandsB LandsB3
PropID08 LandsC LandsC1
PropID09 LandsD LandsD1
PropID10 LandsD LandsD2
There are two major issues. (1) The process/calc must be applicable to a database that is IWP and (2) the sub-summary serial number must be static b/c there is a possibility that a record's status will require that it be deleted, therfore, simply using a count function will not solve my issue.
I thank you in advance for all of your help and will reward points/grades quickly for any solution I receive that solves my problem.