Frank Pytel
Hello; Hoping someone can help with a design issue. I have to learn C# for work. Part of my work will be calling information from a database. Not sure of the type. I thought that it would be good practice to design an application and integrate it with a Jet database. I understand that much of the work will allow me to migrate to SQL or mySQL if needed. So, I am building a grocery shopping list as an example. My question is regarding how to create the tables. I have categories of FrozenFruit, FreshFruit and CannedFruit. I realize that I will be duplicating some of the input (Peaches) but I will need the lists within C# for auto populating or suggestive typing in form txtFields. This is where it gets tricky for me. Should I go with a Brand table(Cambell's, Progresso) listing Soup (Clam Chowder, Chicken Noodle) with a size and price in columns 3 and 4? This will leave out an auto populating Soup list because size and price may differ by brand (10.25 oz Chicken Noodle vs. 10.75 oz Chicken Noodle)? I am a bit perplexed and any advice you can provide would be greatly appreciated. My skill level with database design is below novice. Idiot would be a better descriptive term. I am basically typing my tables into Excel and importing them so that I can have the wizard automatically fill in the NoDuplicates and Key assignment. Thank you in advance for any help. All responses and opinions will be greatly appreciated and helpful. God Bless Frank Pytel