Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Awuah

  1. Awuah

    Assign a value after item is selected

    Thanks a lot all. I will try your suggestions. Regards,
  2. Awuah

    Assign a value after item is selected

    I would appreciate some help with a select box. I have a form that marks certain fields with an asterix to indicate they are required fields. I would like the asterixes(if there is such a word :)) to be shown or hidden based on the selected item from the select box without submitting the form...
  3. Awuah

    Join 3 tables

    Thank you MeanGreen. I appreciate your help. It worked.
  4. Awuah

    Join 3 tables

    what is the syntax for joining 3 tables on a primary key that is present in all three tables. Thank you.
  5. Awuah

    updating a table with data from another table

    Never mind. The update query worked. Thank you. UPDATE tblInventory INNER JOIN tblScanOrderDetail ON tblInventory.BarCode = tblScanOrderDetail.BarCode SET tblInventory.Barcode = tblScanOrderDetail.BarCode, tblInventory.OrderID = tblScanOrderDetail.OrderID, tblInventory.[TimeStamp] =...
  6. Awuah

    updating a table with data from another table

    I have data in a temporary table. I would like to use that data to update an existing inventory table. I have tried an update query but it does not seem to work. Please help. Both tables have the same fields. I would like to update the inventory table if the primary key = the primary key in...

Part and Inventory Search

Back
Top