I have 8 regions all titled their respective region. I would like to be able to create a serial for each record according to what region the record is in.

For example,

North - 01_1, O1_2

South - 02_1, 02_2

East - 03_1, 03_2

Ultimately I am trying to use the serial number to get a image from a folder and display it in the layout. Any tips on how to do that are also appreciated. Thanks.

Edited July 21, 200520 yr by Guest

Look attachment. Is it what you want?

Slick.zip

Thanks for the example. That is similar to what I am looking for.

Right now I created region_calc which is a calc that contains:

Case ( 

Region  = "North Texas" ; "02";

Region  = "South Texas" ; "06";

Region  = "West Texas" ; "01";

Region  = "East Texas" ; "03";

Region  = "South Gulf Coast" ; "07";

Region  = "North Gulf Coast" ; "05";

Region  = "Central Texas" ; "04";

"NM")

I use region instead of referring to a value field because I realized that the field region was equal to a value in the value field.



Then I have id which is an auto enter from the calculation:

region_calc & "_" & Count(Region)

First of all I cannot get the id to display anything other than 2. And secondly I need it to display 02. Any suggestions?

Edited July 21, 200520 yr by Guest

See attached. Note that this solution requires new records to be committed immediately after creation, if you are using it in a multi-user situation. Also, the PseudoSerial will not update if the region is changed once initially selected, and it should not be used as a key field in any relationships, only as an on-screen visual for users.

Slickv2.zip

Thanks for the help. I figured a way for the region number (01, 02, 03 etc) to change according to the region selected. Now my problem is counting how many are in that specific region and outputing that.

I don't need the serial to be outputed. I need it to be used to reference images in a local folder.