Bob Hall
rjhjr at cox.net
Sun Jun 6 10:22:05 CDT 2004
Karen, If you want to do lineages, you'll be using what are called trees. For a start on that, go to my website http://members.cox.net/aatgang. Click on Access SQL, and then Modeling Tree Structures. The article tells how to set up the two different methods of modelling tree structures, and explains why I think Nested Sets are better than Adjacency Lists. For more detailed information, the article names a book by Joe Celko. In addition, he has a new book out called "Joe Celko's Trees and Hierarchies in SQL for Smarties". If you are going to be working with trees, you should probably buy one of these books. Read the article, and decide if you want to proceed. Let me know if you have any questions. On Sun, Jun 06, 2004 at 06:57:05AM -0700, Karen Rosenstiel wrote: > Bob, > Thanks for your response. I believe I can do this. I had not even thought of > doing a lineage search, but now that you mention it, that would be > EXCELLENT! What are your suggestions on this? > > It seems that you are familiar with Zen Buddhism -- tell me more, off list, > if you wish, and I can describe my overall project. You might find it > interesting. > > Thanks again > > Karen Rosenstiel > Seattle WA USA > karenr7 at oz dot net (Spam blocker -- resolve into a real email address) > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Hall > Sent: Saturday, June 05, 2004 7:51 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Web Project > > On Sat, Jun 05, 2004 at 04:21:47PM -0700, Karen Rosenstiel wrote: > > Hi gang, > > I have a web project I am working on and would like your suggestions about > > how to do a part of it. > > > > I have a very long list of the Wade-Giles, Pinyin (both Chinese > > transliterations into a European alphabet) and Romaji (ditto Japanese) > > versions of Chinese and Japanese names in parallel columns. These are the > > names of old Zen masters from the last 1,800 or so years. Different books > > transliterate the names in different ways base on the above systems. This > is > > very confusing for the average person who is not a language scholar to > > follow. > > > > How would you go about setting up a little web search tool so that the > user > > could input a name and get the other variations? > > On the backend, there's a one-to-one relationship between one version of a > name and another. For example, Lin Chi is associated with Linji and Renzai > and not Deshan and Tokusan. So have one table with a column named WadeGiles, > a column named Pinyin, and a column named Romanji. > > WadeGiles Pinyin Romanji > --------- ------ ------- > Lin Chi Linji Renzai > Te Shan Deshan Tokusan > > On the frontend, allow the user to select Wade-Giles, Pinyin, or Romaji. > Whichever they choose, they get a scrollable list containing all the entries > in that column, and a box allowing them to enter a name. They either type a > name or select from the list, and the frontend returns the table row > containing the name they specified, along with its variations. > > For cases where the user doesn't know which version they're dealing with, > you could have the entry box search all three columns. So the drop-down box > to select the transliteration system would have > > WadeGiles > Pinyin > Romanji > Don't know > > The "Don't know" option might load all the names from all three columns into > the list (Union query). > > If you want suggestions on setting up lineage searches, let me know. You'll > have to set up the table differently, and it will need special SQL > statements. > > Bob Hall > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com