>>>>>So, what should I look for? First time I've run across this error!!!!
>>>>>
>>>>>Thanks!
>>>>
>>>>It wants to know which plan_id to use in the select (even though YOU know it is the same value).
>>>
>>>I must have lost my eyesight!
>>>
>>>Egads!!! I have looked at this SELECT for about 4 HOURS and did not see the PLAN_ID in the first line!!!!
>>
>>So now you're sending that plan_id to school?
>
>To heck with that!! I'm gonna go back and start over!!!
I meant only to help with a suggestion of a place where it may get some qualifications, as the complaint was that it wasn't qualified for the task of being selected. Though, there's an alternative, you can make it a truly unique field. Maybe if you made it a magnetic field of expertise, plowed it diagonally, watered it with beer and planted assorted cacti on it? ... ummm, school is easier, eh?
Set random rambling off... (but then it set off in that direction by itself - ymmv)