Hi all. I recently purchased LinksSQL. I have read all the help sections of this site. I have read the soon-to-be released manual cover to cover. I have done three online tutorials on relational databases. I am currently reading Hernandez's book on Relational Database design and implementation. I am still very much a novice.

I am going to ask a question that some of you will probably characterize as "dumb". If my question irritates you, please don't reply. If there's anyone out there who can give me a simple explanation of this or even point me in the right direction, I would appreciate it very much.

Here's an explanation of what I'm doing. I'm building a directory of travel-related links. The links can be categorized by type of trip, for example Bicycling, Hiking, etc. They can also be categorized by location, for example N.America, Europe, etc. I would like to display a main category page that has two sections, Type of Trip and Location. Visitors could click on a trip type like Bicycling, and be taken to a page of subcategories that include locations, and then click a location and get links. Or they could click on a location like Europe, and be taken to a page of subcategories that include trip types. It's one data base, but it has two ways to navigate through it.

The part that confuses me is how I set up the category structure without tons of duplication. I'm sure there must be a way to create each type of trip and each location as single categories, and then get LinksSQL to do the organizational part.

If anyone can take a few minutes to help me here, it would be much appreciated.

Thanks in advance,

Carl