Basic question re option fields

[Jeff_Hager]

Start with this thread and follow the other thread I shared in there.

How to plan out your database

Hey all! Hope everyone is doing well? I’m driving myself a little bit crazy with second-guessing about how to architect where the data belongs in my app. The overall project is quite large (ERP/CRM/Audit Control, Customer Portal etc), but it’s the only way I can get what I want for my business. I’ve split it up into a couple of apps at the moment so I don’t get too complicated. As a business we do contract bottling. That’s when we bottle for other people’s brand. There’s a lot of little b…