Looking for the best way to handle this:
I have one table where phone numbers are in.
In that table there are 7 different Ams_Phone.phonetypes:
34 = Work
35 = home
36 = Mobile
43 = Fax
67 = Alternative Phone 2
68 = Alternative Phone 1
69 = Alternative Phone 3
And of course: Ams_Phone.phone = phone Number.
The column PhoneType is only a number field.
I am going to be placing the results in a different table:
tblNAsCommunication.Purpose and tblNAsCommunication.IsKeyPhone = '1'
So if in "Ams_Phone" Table where Ams_Phone.PhoneType = 34
tblNAsCommunication.Purpose = Work And tblNAsCommunication.IsKeyPhone = "1"
I need to setup a query syntax to do this?
Thanks for any help.