Edit Claim Form (Secondary claim)

[jhkings]

I have a situation where the secondary claim form is showing the dropped insurance plan. This patient use to have Delta Dental of California. He switched to Blue Cross Dental as his primary. He's using his wife as a secondary, which is Delta Dental of California.
When the form is displayed for the secondary claim, the Insurance Plan is listed as Delta Dental of California (patient name). It should be Delta Dental of California (spouse's name). It seems his old insurance is used as the secondary. As I mentioned before, it was dropped and shouldn't be used.

Looking at the code, the query used is this
(SELECT *
from insplan
WHERE Subscriber=286 OR Subscriber=173)
UNION
(SELECT insplan.*
FROM insplan,patplan
WHERE insplan.PlanNum=patplan.PlanNum
AND ( patplan.PatNum=286 OR patplan.PatNum=173))
ORDER BY 3

this query will return all the insurance plan for this patient, including the dropped one.

Any idea how to fix this?

Thank you so much!

[jordansparks]

They can just manually pick the plan they want from that list. They do have to concentrate a little bit in that window.

[jhkings]

They cannot pick the plan as the field is read only.

[jordansparks]

No, when first creating the claim. If the current claim is wrong, delete it and create another. Pick from the list when creating.