Hi there,
I am sorry if i posted this in missed category.
I have update form "frmpro" in this form, I have 3 columns "ProducerID, Producername and Villagename". I use these to generate a serialno. Here is my functional code.
=Format([cbproducer].[column](0),0) & Left([cbVillage].[column](1),2) & Left([cbproducer].[column](1),2)
Here is the result:
ProducerID Village Producername
1 Do To
2 Ri Ju
3 To Ad
There are few producers each have unique ID number. for example:
1. Tony
2. Julie
3. Addy.
I also have a table "tblProductions". Fields: SerialID, SerialNo, etc...What i like to happen is that each time when i click a button to update tblProductions, it should populate as:
Concat: ProducerID & Villagename(First2letter) & Producername(First2leter)
1DoTo0001
1DoTo0002
...
...
1DoTo9999
2TiJu0001
2TiJu0002
...
...
2TiJu9999
3CaAd0001
3CaAd0002
...
...
3CaAd9999
They should be filled into SerialNo field.
Can anyone help please?
I am sorry if i posted this in missed category.
I have update form "frmpro" in this form, I have 3 columns "ProducerID, Producername and Villagename". I use these to generate a serialno. Here is my functional code.
=Format([cbproducer].[column](0),0) & Left([cbVillage].[column](1),2) & Left([cbproducer].[column](1),2)
Here is the result:
ProducerID Village Producername
1 Do To
2 Ri Ju
3 To Ad
There are few producers each have unique ID number. for example:
1. Tony
2. Julie
3. Addy.
I also have a table "tblProductions". Fields: SerialID, SerialNo, etc...What i like to happen is that each time when i click a button to update tblProductions, it should populate as:
Concat: ProducerID & Villagename(First2letter) & Producername(First2leter)
1DoTo0001
1DoTo0002
...
...
1DoTo9999
2TiJu0001
2TiJu0002
...
...
2TiJu9999
3CaAd0001
3CaAd0002
...
...
3CaAd9999
They should be filled into SerialNo field.
Can anyone help please?