>>Probably, the purpose of all these thread is entertainment for people around.
>>When you add something to rowsource, it means that you add something to lookup table. When you add something to master file it means that you may still want to show this value in the text portion of the combo even if it's not in lookup (rowsource). Got it now?
>>Once upon a time, Walter gave you a good advice. I can give you another one: do not try to catch me on down-to-earth tech issues: it's simply not your area.
>>
>Ed,
>
>You are incorrect here on two fronts.
>
>One, if a database design includes a data validation table for a given property of an entity then to allow a value in the entity that is not contained in the lookup file is a violation of the database design.
>
>One is the name calling that has not been directed at you at all but seems readily visible in your responses. In this thread it is you who doing the name calling.
First reply was about integrity.
Now about technicals: I am well aware that this approach offends normalization rules, but if you check thread carefully you will see that it started from particular case, and any specific situation requires specific answers. You cannot take some phrase out of context and use as a proof for another area.
Edward Pikman
Independent Consultant