Multiple combinations of entries

[acrowe97]

I'm making a database for a real estate company that deals with the leasing of office suites. When making the form for paints used on the walls of a suite, there are many possibilities (ex. only 1 color or up to 5). Is there any way to make a form that can add fields to fill in colors as I go or do I have to make room for these fields in the original table?

[ranman256]

You can add all colors to a tColor table then apply them all to the form.
is that it?

[acrowe97]

Sorta kinda. I have it pictured here; I have a wall paint w/attributes and the accent color w/attributes. But I feel like there's an easier way to just add more colors as I go on the form than have all this entry opportunity on the form and potentially not get used. I would do that tColor table, but we use Sherwin-William's color palette, and they have tens of thousands of colors.

[Bob Fitz]

I'm making a database for a real estate company that deals with the leasing of office suites. When making the form for paints used on the walls of a suite, there are many possibilities (ex. only 1 color or up to 5). Is there any way to make a form that can add fields to fill in colors as I go or do I have to make room for these fields in the original table?

In a properly designed database you don' add fields. You add records. The new fields you want to add should be new records in a table related to you Suites table

[acrowe97]

I unfortunately cannot upload my database for you to see completely due to security issues, and my ERD is too large to upload as a PDF and a picture wont upload. I currently have many different colors (Manufacturer/Product Code/Color 1, 2, 3, etc) set up as fields in my table. Any suggestion on how to redesign it would be much appreciated.