Requerying Automatically

  • Thread starter Thread starter DawnTreader
  • Start date Start date
D

DawnTreader

Hello All

I have a query like this:

SELECT
utblPartListPriceQuery.ID,
utblPartListPriceQuery.Partnumber,
dbo_PART.ID, dbo_PART.DESCRIPTION,
dbo_PART.PRODUCT_CODE,
dbo_PART.COMMODITY_CODE,
dbo_PART.MFG_NAME,
dbo_PART.MFG_PART_ID,
dbo_PART.FABRICATED,
dbo_PART.PURCHASED,
dbo_PART.PRIMARY_WHS_ID,
dbo_PART.PRIMARY_LOC_ID,
dbo_PART.UNIT_PRICE,
dbo_PART.QTY_ON_HAND,
dbo_PART.QTY_ON_ORDER,
dbo_PART.QTY_IN_DEMAND,
dbo_PART.PREF_VENDOR_ID,
dbo_PART.BUYER_USER_ID,
dbo_PART.PLANNER_USER_ID,
IIf([UNIT_MATERIAL_COST] Is
Null,0,[UNIT_MATERIAL_COST])+IIf([UNIT_LABOR_COST] Is
Null,0,[UNIT_LABOR_COST])+IIf([UNIT_BURDEN_COST] Is
Null,0,[UNIT_BURDEN_COST])+IIf([UNIT_SERVICE_COST] Is
Null,0,[UNIT_SERVICE_COST]) AS [Our Cost]
FROM
utblPartListPriceQuery
LEFT JOIN
dbo_PART
ON utblPartListPriceQuery.Partnumber = dbo_PART.ID;

notice that the utblPartListPriceQuery Partnumber field is a place where
users can type in a new number and if it matches the ID in the dbo_PART table
then it would show all the other details from the other fields.

this query used to work fine. when the user typed in stuff to the data sheet
the other fields would populate fine from the table. i made some
modifications to the form and query but changed them back and now the
updating has stopped. i looked into an old back up of the forms and query and
stuff, that still does what it used to. does anyone have any idea as to what
hidden setting i changed for this query? i need it to go back to updating
after someone enters a valid part number that matches records in the other
table.

thinking about just importing from the backup and redoing all the
modifications... might be quicker.
 
Hello All

i figured it out. i had set the field in the table utblPartListPriceQuery to
be index with no duplicates. changing it back to no indexing causes the list
to automatically load field information from the other table.
 
Back
Top