Hi
wonder if you could possibly help again need some advice please. I have created a table and form with various drop downs on it ie Department, Year, Cost Centre & Serial No. What I am looking to try and do is from the selcetions taken from the drop downs produce a contract Number seperated with /(back slash) example is FM/11/504/01. I would like to try and add this onto the form so as when I select department the FM/would appear in another box and similar with the other 3 choices to evelturaly produce the contract number which I can then select to produce my letters and lables ect. appreciate any advice