Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Table inside a cell

Discussion in 'Information Technology' started by Marvin van Dongen, Nov 1, 2005.

Tags:
  1. Marvin van Dongen

    Marvin van Dongen
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. Jon Lewis

    Jon Lewis
    Expand Collapse
    Guest

    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


    "Marvin van Dongen" <marvinNOvdongenSPAM@hotmail.com> wrote in message
    news:u$XlmXg3FHA.2872@TK2MSFTNGP15.phx.gbl...
    > 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
    >
    >
     

Share This Page