Matching Customers fomr two tables

G

Guest

I presently have a procedure in Excel which takes data from two Access tables
and matches the Customer from one table to related transactions in another.
The other table has a field in which the customer name is included in a
description of the transaction. The Excel macro identifies the customer in
the description and assigns the customer ID# from the first table. Then an
append query takes the information and appends the info into the transactions
table.

Am I better off leaving this as is or is there a way to do this all in
Access? I have fears of someone accidentally deleting the Excel file and
causing mayhem.

Thanks for any ideas.
 
S

Steve

Transactions as you describe are set up in Access as:
TblCustomer
CustomerID
CustomerName
....
....

TblProduct
ProductID
ProductDesc
....
....

TblTransaction
TransactionID
CustomerID
TransactionDate
....
....

TblTransactionDetail
TransactionDetailID
TransactionID
ProductID
Quantity
Price

Customers can have multiple transactions. Each Transaction can be for
multiple products.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert row, table to table - where append goes to correct record 2
Running SQL from VBA in Macro 1
Update Query - Want to Update Only the First Match 4
Split text in one field into multiple records 5
Joining Tables Vlookup equivalent? 1
Pivot Table – Duplicated Data on Row Labels 2
Matching a product field to another field that are not the same 3
ACC2K3: Multi-table Update Transactions Are Unreliable 11

Top