Hi, I have set up a simple table structure for a recipe database.
tables include a Master table, MealType, Meattype, Speed, and
Ethnicity.
I am going to write the front end of the app in vb.net which will
query for criteria based on the meal types, meat types, speed, or
ethnicity...
For example: Show all recipe's that use beef and are chinese.
This is my first time creating an app like this. I am a first time
programmer.
I created relationships between the master table with the other four
tables. I used the lookup wizard data type when creating the tables.
So I am hoping that a user can use drop down menus which will have the
values from the tables.
Am I going about the right way developing this? I know there are many
ways I can do this...but specifically I am not sure how the
relationships will work when I write the queries.
tables include a Master table, MealType, Meattype, Speed, and
Ethnicity.
I am going to write the front end of the app in vb.net which will
query for criteria based on the meal types, meat types, speed, or
ethnicity...
For example: Show all recipe's that use beef and are chinese.
This is my first time creating an app like this. I am a first time
programmer.
I created relationships between the master table with the other four
tables. I used the lookup wizard data type when creating the tables.
So I am hoping that a user can use drop down menus which will have the
values from the tables.
Am I going about the right way developing this? I know there are many
ways I can do this...but specifically I am not sure how the
relationships will work when I write the queries.