By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,661 Members | 779 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,661 IT Pros & Developers. It's quick & easy.

Help with creating relations

100+
P: 153
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
Oct 27 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Using just one table means there are no relationships

Relationships are a way of connecting tables with relating data.

It sounds like that is what you are trying to do. Use some make table queries to create a series of tables from your data that relate to each other.

Try to break the table up into logical groups. Be sure to add one unique field to all new tables and to create a relationship between the tables by putting a foreign reference to the unique key from table 1 in table 2

I can't help further unless know exactly what the fields are in your table and how they relate to each other.
Oct 28 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.