Populating form field with selected values from shared field

Okay - I got it working by building a relationship and using the list report but I must admit I'm not really comfortable with it.  I agree with your comments about design and have it structured accordingly.  All I'm trying to do is to store in a separate table unique information about a particular Company if they are of a particular Company Type.  I could include the fields in the Company table but I have an aversion to having a fields in a table that are not applicable to all the Companies in that table.