Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!news.glorb.com!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail From: "Arved Sandstrom" Subject: Re: Designing a structure Message-ID: X-Comment-To: comp.databases,comp.lang. Newsgroups: comp.lang.java.databases In-Reply-To: <93ecbfa7-ed35-4210-8192-fdbd9835a98e@t54g2000hsg.googlegroups.com> References: <93ecbfa7-ed35-4210-8192-fdbd9835a98e@t54g2000hsg.googlegroups.com> Content-Type: text/plain; charset=IBM437 Content-Transfer-Encoding: 8bit X-Gateway: time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92] Lines: 39 Date: Wed, 27 Apr 2011 15:21:37 GMT NNTP-Posting-Host: 96.60.20.240 X-Complaints-To: news@tds.net X-Trace: newsreading01.news.tds.net 1303917697 96.60.20.240 (Wed, 27 Apr 2011 10:21:37 CDT) NNTP-Posting-Date: Wed, 27 Apr 2011 10:21:37 CDT Organization: TDS.net Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:77 To: comp.databases,comp.lang. Marco wrote: > On May 6, 4:22 pm, David Segall wrote: > >> Thanks Arved. I agree that the application probably reduces to a >> many-to-many relationship between persons and businesses in one table >> and locations in another and that does lead to the difficult and >> probably off-topic question of designing a GUI to represent that >> relationship. > > Not impossible to implement in a user-friendly way: on the edit form > of one person the user sees the list of addresses and the "+" button, > which leads to the address entry form. After the user clicks "OK" on > the latter, the application checks whether the address already exists > or not (even by applying some euristics, e.g.: "High St." is supposed > == to "High Street"), and proposes to select among possibly equivalent > addresses. New address is only added (and a record on the bridge table > with it) if no existing one exists or none is selected by the user. Potentially some form of autocomplete might be worth considering, at least for address. Nothing new - I believe GMail does it for addresses. Street name is likely the most authoritative field; other fields are either not selective enough (like unit number) or have different possibilities (like municipality). Something like what you suggest clearly has to be available for the general case, or where autocomplete fails due to typos ("how the hell d'you spell that anyway?"). [ SNIP ] AHS -- * change 'two' to '2' to email me --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24