I have a dropdown lookup field on my first form that pulls a vehicle registration from a ZC database.  This is called Vehicle_Registration.  Below this, on the same form, I have a single-line field called Vehicle_Type.  

In the database, every vehicle registration has a corresponding vehicle type.  So, I would like the Vehicle_Type field to auto populate when a registration is entered into Vehicle_Registration.

I am sure this is simple but I've had no luck.

Next, I need this info (vehicle registration) to be carried over across all eight forms.  So on the next form, I imagine there would be a lookup to pull the registration from Vehicle_Type on the first form, and so on down the chain.

Can anyone help me achieve this?  Thanks in advance.