> Ok please don't get me wrong for asking again: one customer can have two
> tax rates? Why?
> Because he's living in the USA and has a taxrate of 25% and lives also in
> Germany and has
> 19%? Hm ... strange ... ;-) . And also the custumer is 'prospect' OR 'not
> active' ... but
> not both ... ;-)
>
>> drop downs in the application, so the customer can easily select a value.
>
> So all these dropdowns are multiselect ...?
>
> I am not sure if I can help you with this. My idea is really to think
> about the design of
> the application and / or the database ... again - please don't get me
> wrong ...
Hi Andreas,
I think we are not understanding each other :-)
It's al the time just 1 value, 1 value for tax, 1 value for customer type.
No multiselect drop downs. But all these fields are of course referencing a
lookup table by ID. But like Regina also said, the performance hit of the
LEFT JOIN seems not worth considering putting junk data in the database that
should be NULL (if the drop down is left blanc)...
I don't know if I made myself clear ?
Thanks !
Nico
