Thank you for taking the time to help Jenny.
I didn't get the optionsID relationship to work. I tried it manually or the graphic way in phpmyadmin.
The name is the same, type is the same. The options table optionID is primary and auto_increment. Table types are all InnoDB. It should work. I did it the graphic way (Designer) with the companyID from the Index Table to the Company Table. I will work on that later tonight.
This is how I expect or want the company index to work.
1. I want to add the basic company data and that is from the Company Table.
2. If they pay to have their company index to show if they have a twitter,facebook or a webpage link, I would like to bring up that company name and switch those variables on. The index would look like the yellow pages that shows company names, addresses and phone numbers, but I would add different links that could be available. I could switch these on in the admin pages.
Once I have this 1st step, I can work on the other relationships to other tables.
Thanks
Mike D