Skip to main content

So I have a list of companies and their products. In order to let users add companies and products, I have to have a record for each. Example:



Is it possible, in card view, to show only one card per company, but have all that companies products on that card? As opposed to one card for each record? (Having 10 Company A cards with one product on each card).


I need random people with the link to be able to add companies and products and the above grid view is the only way I can figure out how to do it with a form.


So that it goes from this:


To something like this:

Yes, you will need to create another table for your products, and then create a linked record field in your companies table that links to the appropriate products for each company.

Yes, you will need to create another table for your products, and then create a linked record field in your companies table that links to the appropriate products for each company.


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. 😕 I might have to look for a different product.

Reply


Terms & Conditions