Thaks opc.three, that makes it clearer.

For me scripts are way more practical than restores. With the scripts all I want is to delete dummy data that I use while developing...

Thanks, that was exactly what was happening.

It's quite standard (at least in Europe!), it's basically a check letter that you generate for verifying a sequence of numbers (like the control digit in a check, a barcode,...

Thanks Sean. By now I've got a very clear idea of what the (mod 23) code does in SQL (code in VBA still pending).

Basically it takes a number 'ID' like...

Thanks Sean.

I'll happily do all you ask for, but there's problems:

-Don't know what an execution plan is.

-Too many tables, functions, a backend, a frontend,...

-And the constraint of some information being confidential....

Thanks for the prompt reply. I'm not sure I get what goes inside the code, but I'll try.

Essentially, the problem is typical values for this table would be something...

Hi Lowell,

I've come across a problem while implementing your code. It works (I expected that!), however, since it's for a mailmerge, when you enter the fields for someone on a...

Thanks, you're probably right and that would be a perfect solution.

I'll try to link that code to my view.

Hi Lowell, thanks for the try, but I think this won't fix the problem. There must be something really simple (like calculated or derived fields in Access!).

The structure is similar...

Thanks both, good replies that will be taken on board.

In a way, you could ideally solve the whole problem with just 1 SP in SQL.

This must be a piece of cake, but the issue (at least for a...

thanks, although that was the easybit, that might help!

Thanks Lowell, but it doesn't seem to be the same standard I'm referring to.

In standard Code128, if you code 'bananas', you'll get ÑbananasÈÓ (it always starts with capital Ñ and...

Yeah, I think we're on the same page now. I've attached a JPG for those who are not that familiar with layer/format issues, showing the code for the fields.

The image...