Forum Discussion
mmacygin
Oct 05, 2023Copper Contributor
How can I fill a field with info from another field
Apologies if this is super simple, but I'm having a challenge figuring it out. I have a DB created from an .xlsx. The data is made up of 3 fields. 1) name, 2) email and 3) roles. In the roles fiel...
XPS35
Oct 05, 2023Iron Contributor
mmacyginYour design is wrong. You still work as if it were a spreadsheet. But you are now working on a relational database that requires specific design rules, also known as data normalization. Learn about that first before you start building a database.
To give you an idea, your model should look something like this: