I have a relationship between to table, acsuTrans_UnallocatedCash and acsuTrans_ReservedCash. The relationship is acsuTrans_UnallocatedCash.Entry_ID = acsuTrans_ReservedCash.UnCashID. However when using the auto complete after typing INNER JOIN, it swaps the two column name. Here is a screen shot to show what I mean. If I type in the table name acsuTrans_ReservedCash and give it an alias (RC), then hit the auto complete, it puts the column names in correctly.