[thelist] Access DB design troubles

[rudy]

> (a) Obviously, you can't/shouldn't/won't offer a drop-down
> containing the names of all of your current customers to 'pick from'
> for the referrer field. That's a fairly major 'bad idea' (TM).
> Which pretty much means it's going to be a write-in field.

nice analysis of the whole situation, ron

make it a write-in field, collect data for a few business cycles (weeks?
months?), and only then make an attempt to match the write-in contents to
existing customers

the quality of the data will, i can assure you, be an eye-opening experience


rudy