Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2011
    Posts
    56

    Unanswered: Multiple Records added at same time Via one Form?

    Basically, i'm designing another stock control project,

    i have the fields:

    Record Number
    Date Items In Stock
    Address
    Postcode

    Item Description
    Qty
    Weight
    Item Location

    now what i wanna do, is on a form, have all this information on one form, BUT have the 4 Items Fields, Repeated about 10 times, to accomodate more than one item per address, is this possible?

    maybe something like a "add another item to this address" button or something?

    is this possible?

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use a sub form
    the items per address are stored in a sub table to product and address/location as an intersection table
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2011
    Posts
    56

    Ok,

    Right, im glad its possible, makes it easier,

    once again, i am a retard, and i havent a clue how to use a sub-table or an intersection table.. can you dumb it down for me please?

    perhaps explain the process a little?

    thanks for everything man

  4. #4
    Join Date
    Oct 2011
    Posts
    56
    sub-table, them things with the + signs on the first column!

    so, how would i create one? is there a wizard? cause i can't find one..

    im trying to work out how'd i'd manually make one

    so have addresses in one table, and items in another table, and link them up somehow?

  5. #5
    Join Date
    Oct 2011
    Posts
    56

    Right, I'm Getting somewhere

    i've seen an example of a subform, displaying a record from the "one" of the One-to-Many relationship, and loads of records from the Many side all colaborating in one smart subfrom,

    the trouble im having is how do i make it?

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    a sub table is slang for a table that sits below one (or more other tables)

    in this case assume that you have a table for product
    and we need to know where individual products are physically located
    using the rules of normalisation that would me we have to store individual instances of products in another table
    Fundamentals of Relational Database Design -- r937.com
    The Relational Data Model, Normalisation and effective Database Design

    so you would have a (sub)table which identified where individual products were located, linked tot he other table. in this case the natural link would be the Product ID (the primary key in your product table, and probably part of the primary key in your productlocations table. as to waht the other part is thats upto you. I'd guess that you would probably have some form of ID on each product it could be a serial number or whatever. if your productlocations table has more information in it then it may be better to call it productdetails where you woudl associate data required for a specific instance of a product (eg the serialnumber, date of build, revision number and so on

    if all products of the same type were located int he same place then you wouldn't need to have a separate (sub)table as you coudl associate the storage location with the product description
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •