stnkyminky
Programmer
I have two tables (1) ZebraDB and (2) tbl_sw_bundles.
ZebraDB contains two columns ID_JOB and ID_BDL.
Sample Data
ID_JOB ID_BDL
C391A1 001
C391A1 002
tbl_sw_bundles contains three columns mybundle, Date_Shipped, and TruckName
Sample Data
myBundle Date_Shipped TruckName
C391A1-001 08/30/2002 UPS
C391A1-002 08/30/2002 UPS
tbl_sw_bundles is populated with data from zebradb via an append query
Insert into tbl_sw_bundles (mybundle)
select Bundle = (ID_JOB + '-' +ID_BDL) from ZebraDB
Where not exists (Select mybundle from tbl_sw_bundles)
The append works great until I Delete a row from tbl_sw_bundles. Delete from tbl_sw_bundles Where mybundle = 'C391A1-001' The next time I attempt to append new rows the select statement fails and find no new records even though C391A1-001 is in table zebradb Scott
Programmer Analyst
<><
ZebraDB contains two columns ID_JOB and ID_BDL.
Sample Data
ID_JOB ID_BDL
C391A1 001
C391A1 002
tbl_sw_bundles contains three columns mybundle, Date_Shipped, and TruckName
Sample Data
myBundle Date_Shipped TruckName
C391A1-001 08/30/2002 UPS
C391A1-002 08/30/2002 UPS
tbl_sw_bundles is populated with data from zebradb via an append query
Insert into tbl_sw_bundles (mybundle)
select Bundle = (ID_JOB + '-' +ID_BDL) from ZebraDB
Where not exists (Select mybundle from tbl_sw_bundles)
The append works great until I Delete a row from tbl_sw_bundles. Delete from tbl_sw_bundles Where mybundle = 'C391A1-001' The next time I attempt to append new rows the select statement fails and find no new records even though C391A1-001 is in table zebradb Scott
Programmer Analyst
<><