Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page