Ms Access Table Design - list or new table
Clash Royale CLAN TAG#URR8PPPMs Access Table Design - list or new table
I have a table:
tblA
ID = Autonumber
Price = Number
Name = Text
The field [Name] contains values from a list. The list has 2-3 values.
I will add 2more values in the list, so total 5values.
What is better for performance for my database.
The field to be list or create another table and place there the values? What is better for database size and speed?
New Design:
tblA tblB
ID = Autonumber NameID = Autonumber
Price = Number Name = Text
NameID = Number
Thank you.
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Go for tables as it easy to maintain & flexible. To speed up you can create an index on the field.
– Santosh
57 secs ago