Multiple same field names?

F

Febra

I am wondering how to best to set up a table to list ingredients of food
products in a food service. Most of the food products have multiple
ingredients so I am unsure how to set up the table. I was wondering if it is
possible to set up many field names with the same name, in this case,
"Ingredients". The goal would be to run a query to find food products that
met specific criteria, such as for a specific food allergy.

Thank you for your help,
 
B

Brendan Reynolds

No, you can not have more than one field in the same table with the same
name.

There are at least three tables required here - Products, Ingredients, and
an intermediate linking table to model the many-to-many relationship between
Products and Ingredients - one Product can include many Ingredients, while
one Ingredient can be included in many Products.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
F

Febra

Thank you. I appreciate your help!

Brendan Reynolds said:
No, you can not have more than one field in the same table with the same
name.

There are at least three tables required here - Products, Ingredients, and
an intermediate linking table to model the many-to-many relationship between
Products and Ingredients - one Product can include many Ingredients, while
one Ingredient can be included in many Products.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
Click to expand...
 
Top