Kinda like your way... but the compiler doesn't like where I've placed astericks:

USE [TrackIT]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER [dbo].[trUpdateBulkPurchases]

ON [dbo].[tblTransactions]

AFTER UPDATE

AS

BEGIN

UPDATE tblBulkPurchases

*(tblBulkPurchases.PO_Number,

tblBulkPurchases.Quantity,

tblBulkPurchases.Transaction_Number,

tblBulkPurchases.Quantity_Remaining,

tblBulkPurchases.Unit_Price,

tblBulkPurchases.Software_Description,

tblBulkPurchases.PO_Date,

...

Correct... do need to associate by PO = PO... thanks.... is the word INSERTED.____ appropriate to use?

I have an ASP.net application, no encryption, just a Record#, UserName, PW, and SecurityLevel, really simple file, 30 users tops.

Custom table I'm designing.

Is this someting I create or reference from my SQL Server database I already have set up for my receiving table?

Got error:

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

Msg 7303, Level 16, State 1, Line...

Something like this?:

INSERT INTO tblTransactions(

PO_Number,

Buyer_Initial,

Qty,

Unit_Price,

Software_Description,

AllocationAccount,

PurchaseAccount,

HeatTicketNumber,

PurchaseCostCenter,

PO_Date,

Transaction_Date,

Transaction_Number,

AllocationDate,

AllocatedYN,

EndUserFirstName,

EndUserMiddleName,

EndUserLastName,

LAN_ID,

EndUserLocation,

TermDate,

EmployeeStatus,

Notes,

LicenseAvailable,

Transaction_Type,

AllocationCostCenter,

SoftwareShortName,

PC_Name,

TransferedSoftware,

TransferToFName,

TransferToLName,

TransferToLANID,

OriginalTransactionNumber,

TransferToCostCenter,

CostCenter,

SWstatus,

SWstatusReason,

EmployeeEmail)

SELECT PO_Number,

Buyer_Initial,

Qty,

Unit_Price,

Software_Description,

AllocationAccount,

PurchaseAccount,

HeatTicketNumber,

PurchaseCostCenter,

PO_Date,

Transaction_Date,

Transaction_Number,

AllocationDate,

AllocatedYN,

EndUserFirstName,

EndUserMiddleName,

EndUserLastName,

LAN_ID,

EndUserLocation,

TermDate,

EmployeeStatus,

Notes,

LicenseAvailable,

Transaction_Type,

AllocationCostCenter,

SoftwareShortName,

PC_Name,

TransferedSoftware,

TransferToFName,

TransferToLName,

TransferToLANID,

OriginalTransactionNumber,

TransferToCostCenter,

CostCenter,

SWstatus,

SWstatusReason,

EmployeeEmail

FROM OPENROWSET('MSDASQL',

'Driver={Microsoft Access Text Driver (*.txt, *.csv)};DefaultDir=C:\Users\DCAMPB\Desktop\;',

'SELECT * FROM Master.csv;' )

What does ColumnList mean?... actually listing the columns?

I'm thinking I can change the extension back to .csv and open in Excel, rename the columns to exact names of receiving table, insert missing columns, etc., then rename back...

That seemed to work well creating a file that closely resembled the below. If I wanted to populate an existing file with an identity key with this data is that...

I have this as a .csv file also which may be easier to handle (?)

Could the above be a permissions issue? It is peculiar that in VS my ASP.net SqlDataSource has the "Generate INSERT, DELETE, MODIFY Statements" grayed out... my other tables do not...

That makes sense about the number of transactions and those are consistent with the dependent triggers. I dropped them temporarily and recreated them and the number of transactions reponded accordingly....

Your above code recommendation works perfectly... thank you for sharing! - Brian

The scenario is an ASP.net/VB.net/Javascript application has a popup that lists all the user's software. A dropdownbox allows for a Yes/no deactivation of the software, thus triggering an update that...