Concatenation

[Mitsuki]

Hello,


I have a query ... i hope that you can help me solve it!

I am creating a database where i was the ID to be concatenated from 3 fields. I did that well i think i did but when i save the concatenation of the ID is not saved in the table ..


In the ID field in the form i added this in its control source

[ =[Field1] & "" & [Field2] & "" & [Field3] ]

.. In the form it concatenated fine but in the table all the fields are saved except for the ID ...


Help please!

 

[wazz]

what if you made the PK of the table a combination of the three fields and eliminate the ID field? sounds unusual but might do what you are asking?.?

 

[Mitsuki]

I didnt get you please expain