>>>Well, tell me which framework you use, so that I can avoid it since it cannot work with a unioned sql-select.
>>
>>This is not what I meant.
>>
>>IAC, we'll contact the client. As this particular record need to have a fix value for a pre-defined field, that value should then be read only at edit time.
>
>Maybe you should keep this record in the separate table? just an idea :)
If we keep it in a separate table, that would imply to change several designs in the application. I still think this is a bad design for what they need but the client is always right. :)