I always seem to "have a lot of explaining to do" - and I will try .
What I have done seems rather simple - I have a table consisting of
sku,info,price1,price2,price3......,price12.
I have an 'parameter append query ' allowing the specification of sku number
desired and the successful result being written to workfile table with the
same layout.I can enter all needed skus , some duplicates to acheive a proper
result in the work file.These items in the workfile represent a part number
list for a job,
with 12 different prices .
When is said a "failed" query , I guess I really ment a query with no
results , which
would mean in this case "no such sku "
As for the table refresh It's purpose is simply to keep the workfile table
current
as the queries are adding records or deleing them to prepare an empty
worksheet
table for a new quote.
