Default Value in Table based on two fields

[kaiana]

I am trying to set a default value in a table based on two other fields in the table.

This table gets its records via an append query. It has a primary key "SupportNoteID" and I have a field ("SupportNoteNumber&quot that I want to fill with the default value of [SupportNoteID](primarykey of table) &[ServiceCallNumber](appended with record). I tried putting =[SupportNoteID]& [ServiceCallNumber]as the default value in the table but this gave me an error saying it did not recognise the field.

 

[annsolomon]

How about appending your ServiceCallNumber first then immediately run an Update query to update SupportNoteNumber to [SupportNoteID]& [ServiceCallNumber] Ann

 

[kaiana]

Ann,

Thanks for the idea, I had already tried that but couldn't get it working, my SQL is a little rusty. If this is the best option I will keep trying and maybe paste my code to see if I can get any suggestions on where I am going wrong.

Tanya