>My UI allows user to enter the data; so there is a potential for them to enter wrong value; nothing I can about it. If I give them only combo boxes for selecting from pull-down lists some won't be happy. Thank you for your input.
>
When user is creating a child record, he/she should not be required to type the parent key. The PK is inserted automatically with the child record.
If it's not broken, fix it until it is.
My Blog