Thanks for posting.

Are you familiar with our permalinks plugin?

http://www.interactivetools.com/add-ons/permalinks/

This plugin will let you create custom URL's for each of your records. It can also be configured to automatically create the custom URL like /category/subcategory/listing

I think this will be the best place to start.

Have a look through the plugin description and let me know if that sounds good to you too.

I'm thinking to create a Business Directory with CMSBuilder but need some advice in order to define properly the tables I need.

I'm starting with 2 tables (Categories / Listings). Listings will have a field to match the proper category where it fits and basically I got this thing going. What I'm thinking here its how can I create the SEF urls for each listing.

Example.- I'm looking for something like this:

Root/Category name/Subcategory name/Listing name

So, any ideas on how can I get going the categories table in order to get the proper path on each listing or while browsing the directory?

My categroy table goes like this:

ID
Category name
Parent (Select field)

My listings table goes like this:

ID
Listing
Category (related to the category table)
URL
Phone number
Listing description

Thanks in advance for pointing me to the right direction, CMSBuilder might be agood fit for this.

Jesus