Method Community

I am trying to link fields on the Default work order template and fields from customer equipment together.  Is there a way to bring both of these tables together?  

I have a huge problem.  I discovered that my admin role had a missing Mobile User role.  I went to add this to my Role/Groups for Admin and then when I logged in with my user name, then the only roles I had available are Mobile USERS, Support, and Sales.  I have no ADMIN role anymore even though I am setup for for those tab links ...

I am looking for a way to create a dropdown fields that are linked and related based on the prior selection.  For example:  Let's say I choose a dropdown field that has a list of 10 different Manufactures of cars. (i.e.: GM, Ford, Chevrolet, Buick, VW, BMW, Saturn, and etc.)  Based on which Manufacture I select I would like to ...