[thelist] Access DB design troubles

Tim Burgan burgan at iprimus.com.au
Thu Jul 17 18:43:58 CDT 2003

Thanks for the suggestions Ron,

I guess I had thought about these issues in the back of my head already.
I have a couple ideas of how to get around it.. we'll see. Most probably
I'll be posting to thelist again when another problem shows itself.

Thanks again
Tim Burgan
| (1) I would probably think about adding one or more 'dummy' rows that you
| could match to new customers who were referred by "no one", or "print ad",
| or "other".
| (2) I think the referrer matching is tougher than folks are leading you
| to believe:
| (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
| That's a fairly major 'bad idea' (TM). Which pretty much means it's going
| to be a write-in field.
| (b) Write-ins means you will have a fun time matching my manually entered
| referrer field value of "Tim Burgan" to your db entry of "Timothy Burgan".
| [And that's assuming I get the name right and don't misspell an "i" for
| "a" near the end of your last name!]
| (c) How are you going to properly assign a referrer to the 'correct' Tom
| once you have six different customers going by that name?

More information about the thelist mailing list