Backtrack

[crazybake]

I've gone in too deep and have two requests for help.

1.) I do backup my database each time I make a change. However, this time, in my rush to fix potential issues, I have added tables and added/subtracted relationships. At this point, I have completely confused myself. From your point of view, what is the best method of systematically deconstructing and reconstructing relationships.

2.) I do have an older version, but I am stuck on an obvious relationship issue:

I have 4 tables: Employees, Assets, Transactions and Line Items.

Key fields so far... Employees:ID#::Transaction:ID#, Assets:Item#::Line Items:Item#.

I have a layout within Assets that shows all currently checked out items, by which employee. I want to be able to click on the employee name and have it go to that employee. Unfortunately, my relationships are not correct, as it goes to the employee who FIRST checked out the item... any help?