Odd SQL question

[MisterMan]

Hello,

I have three tables:

Table1 has personal information. 1st name, Middle initial, Last Name and ID# (PK)

Table2 has phone information. #, Phone type, Time to Call and ID# (PK)

Table3 is a simple table with Phone Type and Call Type (Short or long).

Table3 exists so that I can have the type of phone call in the final table along with the rest of the information without having to do the additional data input. However, say there is a situation where I want a specific ID number with a "Phone Type" that would mean a short call to be listed as a Long Call. Is there any way to do this?

 

[jsteph]

Short of changing the CallType ID for that PhoneType, anything else would be messy workarounds. You could put an IIF() statment in the sql column for Calltype to force the calltype for that particular ID. Performance may suffer, but that would do it.
--Jim