It dosn't matter what shows in the fe. The be is where the relationships are defined and enforced. If you want to see the relationships in the fe, add the tables to the relationship window. I think the join lines are drawn automatically when the second table is added. You may have to refresh the window.