Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2014
    Posts
    1

    Unanswered: Statistical Table Via Data Table

    First Time Post Here.
    I have 2 tables in a Mysql database. Everytime a new part is sold an insert occurs in to the PartsSoldTable. What I want to do is everytime an insert occurs into the PartsSoldTable. I want to somehow update the AveragePriceTable showing the updated average price. I would also like it to be dynamic in that say for instance a new part "Part F" is inserted into the PartsSoldTable, The AveragePriceTable would add a new entry showing this and list its average.
    I am unsure if something like this is even possible and if so how should I go about it. On a side note I would actually be willing to pay someone to figure this out for me.
    Attached Thumbnails Attached Thumbnails DatabaseQuestion.PNG  

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Why have an average price table?

    You can always calculate the average price when required using the average function in a query.
    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
  •