I don’t think that is going to work. If I am understanding what you are saying, I would have to create a new “column” for each company to put the products into. You can’t create columns aka fields using a form. And even if I did that, I would have to manually change all the “linking” every time some added a company and their product line.
I am creating a large database. The initial amount of information that is being entered is a lot. Once most of the information is entered, there will only be a few entries every once in a while. This information needs to be as automatic as possible.
Giving access to individuals is impossible, as collectors all over the world are adding to this database, which is why I need the form option.
If I could create a multiselect field from a column from another table…that would work? I don’t know. :confused: I might have to look for a different product.