A few posts back, you are correct on the results for the query page. The results show the company name and the options that are linked to them.
I cannot make the optionsID1,optionsID2,optionsID3 and optionsID4 unique. If I do, I cannot add the same data. The companyindextable will reject the same number. Each one has to be unique.
I think I had optionsID in one of the posts and that caused some confusion.
So I have 9 pictures from each table, the design and inserted data. The last 2 pics are the query and the results.
Maybe starting from the beginning would be a good idea :) I guess I need to add the last 3 in the next post.
Please let me know what the AS operator is.