Hello again everyone!
I need help on the proper way to setup a database and I think I can get the form from there but I Will try to explain my dilemma.
I have a parent table that has the brochure number and a jpg (stored in database) field.
Each brochure can fit into one or more categories (up to as many as 10 differing categories actually). I have 1-many linked the categories to the parent table via brochure number. On my form I am using a browse to select the different category types. The categories are stored in a category table and thus I am using a table lookup to fill the category field.
Each category can be subdivided into more detail as related to the category. For example we could have a brochure #12345 that matches multiple categories such as family, individual, business, etc. The detail about the category could also be multiple selections. For example, for the category family it might include details of kids, home, cars, pets. And for the category of business it might include, employees, auto, fitness. And for the category individual it might show details including hobbies, money, and home.
My question basically is, "Is there a recommended or better way to set this up?" And for presenting and data entry is there a better way than the utilization of browses to enter data?
Thanks in advance and I hope it is more than "clear as mud".
I need help on the proper way to setup a database and I think I can get the form from there but I Will try to explain my dilemma.
I have a parent table that has the brochure number and a jpg (stored in database) field.
Each brochure can fit into one or more categories (up to as many as 10 differing categories actually). I have 1-many linked the categories to the parent table via brochure number. On my form I am using a browse to select the different category types. The categories are stored in a category table and thus I am using a table lookup to fill the category field.
Each category can be subdivided into more detail as related to the category. For example we could have a brochure #12345 that matches multiple categories such as family, individual, business, etc. The detail about the category could also be multiple selections. For example, for the category family it might include details of kids, home, cars, pets. And for the category of business it might include, employees, auto, fitness. And for the category individual it might show details including hobbies, money, and home.
My question basically is, "Is there a recommended or better way to set this up?" And for presenting and data entry is there a better way than the utilization of browses to enter data?
Thanks in advance and I hope it is more than "clear as mud".
Comment