Hi guys, first post
my problem is quite simple (as far as i can tell) but none-the-less i'm stumped.
what i want to do is merge 2 fields into a separate field with the first field being Unique_Id (autonumber, indexed and no dupes) merge with the second field Type (3 letter field) so it should populate the third field automatically as NDE123 etc , but what i also need (which looking around the internet for afew hours held no aveil) is for it to be automatic even when a new records is made, so when a new record is inevitably made the first field will be autonumberd, the 2nd will have a default value, so it will mostly be entirly automatic, is this possible? or am i clutching at straws.
Thanks, Callum
my problem is quite simple (as far as i can tell) but none-the-less i'm stumped.
what i want to do is merge 2 fields into a separate field with the first field being Unique_Id (autonumber, indexed and no dupes) merge with the second field Type (3 letter field) so it should populate the third field automatically as NDE123 etc , but what i also need (which looking around the internet for afew hours held no aveil) is for it to be automatic even when a new records is made, so when a new record is inevitably made the first field will be autonumberd, the 2nd will have a default value, so it will mostly be entirly automatic, is this possible? or am i clutching at straws.
Thanks, Callum