Hi all,
I'm starting to write some import routines and though it would be a good idea to be able to match existing data with data for import.
I was thinking sometihng along the lines of:
3 tables & 1 query
table1:
A list of fields, the type of check to do (EG LIKE, = , > , etc), and a number to return if true (the weight)
table2:
The exisitng data - in my case names and addresses
table3:
the data to import - names and addresses again.
Query1:
resturns rows with Table2 Primary Key, Table3 Primary key & a sum of all the weights where the checks listed in Table1 returned true
I could then filter query1 using a threshold number against the returned summed weights.
(Hope I am making some sort of sense
)
Has anyone done anything similar?
Could you give me some pointers?
All the best
Marc
I'm starting to write some import routines and though it would be a good idea to be able to match existing data with data for import.
I was thinking sometihng along the lines of:
3 tables & 1 query
table1:
A list of fields, the type of check to do (EG LIKE, = , > , etc), and a number to return if true (the weight)
table2:
The exisitng data - in my case names and addresses
table3:
the data to import - names and addresses again.
Query1:
resturns rows with Table2 Primary Key, Table3 Primary key & a sum of all the weights where the checks listed in Table1 returned true
I could then filter query1 using a threshold number against the returned summed weights.
(Hope I am making some sort of sense
)Has anyone done anything similar?
Could you give me some pointers?
All the best
Marc
