I need to join 2 tables together using 2 fields. For Example, I need to join 2 tables to beginning milepoint field and ending milepoint field. I thought I could use Add Join in thedata management box but I can't seem to get that to work. Any suggestions?????
Have you read this help page: Joining attributes of one table to another?
Also, is this what you mean by join (adding matching columns onto records based on a matching attribute value)? Sometimes people say "join" and mean something else entirely.
Yeah, that's the add join. I was reading it some more I don't think that will work. Because, I need 2 fields to 2 fields. Let me explain some more. So, in one table I have a field bmp and a field emp. Like such 0.123 and 1.234. Then I have another table with a field bmp and a field emp. Like such 0.123 and 1.234. I need to join the 2 fields on both tables. So, in the end I'll end up with one table with 4 fields that are the same.
I don't know if this would cause too much extra work or not, but it sounds like something that one could do rather quickly in Microsoft Access.
Just curious, do the mile point values repeat themselves on multiple roadways, or do they each have a unique value?
If I am understanding you correctly, you probably have duplicate "bmp" entries and you only want them to join "IF" the "bmp" AND the "EMP" are the same as the other table row. Someone that knows python might be able to get you going in the right direction. I just don't know python well enough to say it can be done.
My workaround would be to add another field in and field calculate the value to be a combination of the bmp and emp.
Do the same for the other table. I know it adds extra fields, but they would then be unique for joining purposes.
Food for thought.