Consulting

Page 3 of 3 FirstFirst 1 2 3
Results 41 to 43 of 43

Thread: Adding record from one table to another where the Employee ID is the same

  1. #41
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    The power is in the Master child links, which links the Auction to the items and bidders and the Items to the bidders and winners, which are actually the same thing just presented differently.
    There is also the power of the Queries that supply the forms, they can present the data in different orders, so the Winners form on it's own tab just presents them as they happened, but the one on the Item Dis form presents them with the last one at the top.
    There is some fairly simple VBA to update the forms by requerying them etc.
    It doesn't at the moment check if the Auction Item quantity is greater than the Item Stock Quantity but it can.
    It could also control the Item stock level when you set the auction level.
    Once the data is in there and you have the Auction you can then run analysis on what sells best and at the most profit, Who is consistently the best bidder etc.
    How many more products could have been sold if you had more stock.

  2. #42
    VBAX Regular
    Joined
    Dec 2017
    Posts
    43
    Location
    Hey OBP, thank you for taking the time to show me and explain access relationships, subforms and the best way to run access. I am going to work on learning more about relationships between tables because I know I lac in that area.

    Thank you again you are a life saver!

  3. #43
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    KDC, you are welcome, it is my retirement hobby.
    A good old Access book would help a lot, it won't have all the new fangled stuff that has been added to Access over the years, but it will have the Basics of Relational Database, Relationships, query, Form and Report Design.
    Or you can ask me on here or by email if you need clarification on something.
    I have attached a summary that I wrote many many years ago that might provide you with a starting point (or not).
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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