Recent content by AccessStudent

  1. A

    Create a query that copies values from a table and updates when other tables values are changed

    Okay thank you that actually helps a lot I wasn’t sure if I should add primary keys either because it didn’t seem to change anything at first so I removed them but then I made a lot of changes. I’ll get reading up on normalization since during my original questions on google I saw that pop up a...
  2. A

    Create a query that copies values from a table and updates when other tables values are changed

    The Table All_Sites is receiving information from a form the Columns are Item_Main Item_Sub Total_Onhand Site_Loc From the form which is name Inventory_Form I have created drop down lists which show the 4 different locations the different items and then the sub items which are sorted by the...
  3. A

    Create a query that copies values from a table and updates when other tables values are changed

    Thanks for the advice I’ll take some pictures and write a more in depth description for the question.
  4. A

    Create a query that copies values from a table and updates when other tables values are changed

    I have a table called All_Sites and a table called Budget_Table I am trying to copy all the values from All_Sites to Budget_Table. I need Budget_Table to update whenever new values are added to All_sites. I tried using an update query and entering [All_Sites].[column name] but it doesn’t seem to...
See more
Top Bottom