K
ken957
I have a very long table using a limited number of company names, I have
another long table with many of the same or similar company names. I wanted
to make a table without duplicates of the the company names used in the first
table, then work on establishing relationships with the names from the second
table.
I made a table with only three fields, autonumber, CompanyNameListA,
CompanyNameListB. I pasted all 20,000 plus companynames from listA, made a
totals query grouping on company name and using MinOf the autonumber field.
My delete query correctly displays the records I want to delete but only
gives the "cannot delete from specified tables" error
The only relationship between any tables/querys is between company names
from ListA and the Totals Query
another long table with many of the same or similar company names. I wanted
to make a table without duplicates of the the company names used in the first
table, then work on establishing relationships with the names from the second
table.
I made a table with only three fields, autonumber, CompanyNameListA,
CompanyNameListB. I pasted all 20,000 plus companynames from listA, made a
totals query grouping on company name and using MinOf the autonumber field.
My delete query correctly displays the records I want to delete but only
gives the "cannot delete from specified tables" error
The only relationship between any tables/querys is between company names
from ListA and the Totals Query