I was wondering if there was any way of created a field name or field name default from a combination of the values in 4 other fields. Basically I have 90,000 devices on 11 wafers that are mostly unique. I would like to build an access database to keep track of the information. The only problem is the primary key must be unique, which I will not have. Right now I have each device location in 4 fields (Wafer #, Die #, Row, Column). Each of these fields are have linked tables with more data in them. What I want to do is create a useful primary key that would basically be ([Wafer #] +"_"+ [Die #] +"_"+ [Row] +"_"+ [Column]) (ex. 11_4_B_A). At least thats how I would write it in a programming language. I have tried to do different combinations of this and it doesn't seem to work. If all else fails I can just use the autonumber, but I would like something that is useful.
Thanks,
Robert
Facebook
Twitter