Database tables

[pika2112]

Hi I am having a problem related a database I am trying to make!



I work in a elderly home and the problem is the following:

We have a list of meals, like and each meals has like 2/3 core ingredients, like fish, rice, etc. Like this:

Meal Cod	Name	Ingredient1	Ingredient2
M1	Rice and Fish	Fish
M2	Potatos and Steak	Meat	Potatos

And for my clients I have a list os restricted ingredients that they cant eat, like:

Client Cod	Name	Restriction1	Restriction2	Restriction3
123	Zac	Fish	Meat
234	Carl

And what I want is for isntance make the tables and them relate them so I can make a query that tells me that Client 123 and Client 457 cant eat M1. Is saying I want to know what meals cant my costumers cant eat.

Can someone help me!

Its kind of urgent, because we need an automated way to make this so we dont make mistakes!

Thanks Again!

[orange]

Step back from building tables and describe to us and to yourself exactly WHAT you are trying to do. Keep it in simple plain English -- no database/Access jargon. Until you understand what it is you are trying to accomplish, sufficiently well that you can tell others, you probably are still in analysis phase.

There is an old expression ---if you can't describe it, no one can build it.

Here's a sample of the sort of level of detail necessary to understand your issue/opportunity. From RogersAccessLibrary

Narrative
ZYX Laboratories requires an employee tracking database. They want to track information about employees,
the employee's job history, and their certifications. Employee information includes first name, middle initial,
last name, social security number, address, city, state, zip, home phone, cell phone, email address. Job
history would include job title, job description, pay grade, pay range, salary, and date of promotion.
For certifications, they want certification type and date achieved.
An employee can have multiple jobs over time, (ie, Analyst, Sr. Analyst, QA Administrator).
Employees can also earn certifications necessary for their job.

Here is a tutorial from the same site that should help.
you. You have to work through it.

[pika2112]

Hi!

So, its like this.

I work in a home for elderly people. And we have a list of meals that we make for them.
But what happens is that there are some costumers that have some food restriction, for instance cant eat meat. So if and core ingredient of the meal matches a restriction of a costumer he cant eat that meal. A costumer can have many restrictions and a meal also haves many core ingredients.

What I wanted is like make a query or something that says to me that Meal1 cant be eaten by costumer X, Y and Z, and if possible count how many cant eat it.

Thanks for the help!

[orange]

Did you look at the tutorial I suggested in my previous post?

you are dealing with (at least)

People
PeopleFoodRestrictions
Meals
MealIngredients

How these things interrelate is determined by your Business Rules.
Work through the tutorial and you'll be in much better position to do this database.

[alansidman]

Is this a continuation of this issue raised while trying to do it in Excel

http://www.mrexcel.com/forum/excel-q...if-macros.html

If so, here is the same solution only in Access this time.