table population

  • Thread starter Thread starter pcslave
  • Start date Start date
P

pcslave

I have reviewed the knowledge base and could not find the answer to my
question.
I have a table, call it NewItemCust, with one field, Cust#, containing 86
entries. I have another table called NewItemData, with fields Cust#,Item#,
Description, Cost, Sell, Pack and Size., which can contain anywhere from 10
to 35 entries. I want to create (append) to an other table called NewItemRvu
all data in NewItemData, except I want the Cust# to cycle through the
NewItemCust table so the result will show all data repeated for each entry in
NewItemCust. The end result for NewItemRvu should be all entries from
NewItemData duplicated 86 times, with only the field Cust# being different.
The table NewItemRvu is then used through various queries to print item tags
for customer use. I can "manually" append the data by running a query and
manually typing in the next Cust#, but would like to automate the process so
that each record in NewItemCust is appended, then the next record, etc.,
until done.
Any assistance would be appreciated.
Mike
 
Mike,

Make a query with both tables NewItemCust and NewItemData, no joins.
Make this into an Append Query and nominate NewItemRvu as the table to
apend to. Run the query, should give what you want.
 
Steve,
Tried it and works fine. I appreciate your help; can't believe it was that
simple. Sometimes, one makes things harder than they need to be. I sure did.
Thanks again for all of the help.
Mike

Steve said:
Mike,

Make a query with both tables NewItemCust and NewItemData, no joins.
Make this into an Append Query and nominate NewItemRvu as the table to
apend to. Run the query, should give what you want.
I have reviewed the knowledge base and could not find the answer to my
question.
Click to expand...
[quoted text clipped - 13 lines]
Any assistance would be appreciated.
Mike
Click to expand...
Click to expand...
 
Very good, Mike.

By the way, as an aside, I should mention that it is not a good idea to
use a # as part of the name of a field or control.
 
Back
Top