Hi...I'm new but decided to take on learning access programming for my job and I'm having trouble building relations. Any help would be very appreciated!
So here's the jist of the program...I have a bunch of fields that I have the program read through and check to see if one number is missing and then reads through the serial numbers which have asset numbers within them but has to remove the characters of A-Z so it can be compared to the serial numbers. I got those working all fine and dandy...took a lot of work because I don't program...but originally when I had inputed the data...all the rows had the corresponding data but when it outputed into an excel sheet it moved the rows with problems to the top (the ones missing values) by setting a row at the end equal to negative 1by creating a separate check field...and so I thought my relationships were wonderfully working but to my unfortunate suprise...when I entered the data in a different way...it didn't work. The program has a first and last name that corresponds to each serial number. From there, there are three other numbers which are entered seperately but should all have corresponding values equaling one another.
So here's what I need to know...how can I first organize those three rows by saying where A1=A? then match them together. And then from there create a relationship between those three numbers and a seperate relationship between the serial number with the first and last name? Do I really have to sort through everything for the three numbers or is there a way that I can get the relationships to understand that ACG10000399 = ACG100000399 in a different row?...I also have the option of creating another table where based on something I've already done I can cut out the ACG so they are just numbers...but am I looking for the right thing? Am I supposed to use relationshis to do this or is this something much more complicated? I hope I'm not in way over my head.
Again any help would be much much much appreciated.
Cheers
Kosmös