Table inside a cell

[Marvin van Dongen]

Hello,

I'm working with MS Access 2003 now, trying to build an App to manage
recipes. What i want is the following

Table rec (recipes)
Table in (ingredients)

I want a field in rec, named in, wich contains:
1. relation to in (by ID num.)
2. the ammount of the specified ingredient
3. some other information

So basicly wat i want is a Table inside a single cell. Is such a thing
possible? And if it is, how do I build it?

Tia,

Marvin

 

[Jon Lewis]

You need a third table. Each row in this table should hold RecipeID,
IngredientID, IngredientAmount, Other info.

You need to be working with Forms not Tables.

Your main form will be bound to your Table rec. You can then have a SubForm
bound to the third table showing all records in your third table where the
RecipeID's match.

The New Form Wizard and the ToolBox Wizard should walk you through how to
set this up.

HTH