Ciugk

Clash Royale CLAN TAG #URR8PPP Ms 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. Go for tables as it easy to maintain & flexible. To speed up you can create an index on the field. – Santosh 57 secs ago By clicking "Post Your Ans...

Clash Royale CLAN TAG #URR8PPP multi vendor e-commerce database In my database i have several tables including : AppUsers, Orders, Products I want user be able to sell and buy products and I want users be able to buy shop's products as well (which wont have a user as seller, i.e. seller should be null) and there is also OrderStatus which defines status of a order. My question is, shall I use 'Orders' table to store who is seller and buyer and status and other info or I shall create another table? Please help me find best database schema for this situation. Thanks. 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.