Search results

  1. O

    Relationships, table _1, UOM, list box

    Lol, I'll get there. My company is paying for a days one on one tutorial, so I wanted to get the basics on my own and most of the labour intensive work out of the way.
  2. O

    Relationships, table _1, UOM, list box

    got it! Feel stupid now. Trying to run before I can drool :rolleyes:
  3. O

    Relationships, table _1, UOM, list box

    @JLCantara That’s great, but it still does not tell me how to restrict the UOM descriptions for the end user to select from in numerous fields/list box in one table. :banghead: :):):) Thought this would be common place in product and order BD's? I'll have a poke around with quires; I'll...
  4. O

    Relationships, table _1, UOM, list box

    Thanks for the replies. I think a picture paints a thousand words, hope this works. please see attached. Disregard 1Qty & 1UoM, 2Qty & 2UoM fields in the product Table, as you can see I'm playing with a many to many relationship as a conversion table. lol next post.
  5. O

    Auto populate date field just once (on creation)

    You could also use =Date() to show a date only.
  6. O

    Relationships, table _1, UOM, list box

    New to Access and trying to get my head around relationships. Here goes. I have a table for tblProducts with multiple fields of units of measure(UOM) which will be list boxes for the end user to select on a form: QuantityUOM WeightUOM 3x DimentionsUOM I have a table of tblUOM that I want to...
Back
Top Bottom