verification qry!

[tom4038]

I have a linked table with lots of telephone numbers



its called smslog

problem is if someone sends a text to the number it could upset the data

so i want to verify the telephone numbers, comparing them against numbers listed within unitDETAILS.PhoneNumber. If it's listed I want to add the data to smslogACCEPTED if it is not known i want to add data to smslogREJECTED.

Simple? Probably to some but im still learing, anyone got any ideas?

Eddited to add: This needs to be done on a live basis and run immediately on the data beeing recieved in smslog, hope this doesnt cause to many problems but if i need to run it every few mins it could cause problems!

[dcrake]

for a start why have two tables?why not have one table with a boolean field named Accepted. If the number is valid then set this to True otherwise False. Then you can simply query the same table using True or False Conditions.

You have not said how the data is getting into the linked table in the first place. I would suggest that validation is performed at the earliest stage possible.

David