If you are able to have a normalized data set of 'business_titles', you
could set up an db table, say
tbl_business_titles
- titleid
- title
- sort rank
then, in your main table, you store the id of the business title, thus all
records in the main table could be sorted by business_title and the sort
rank would be stored in 'tbl_business_titles'
hth
charlie hanlon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233770
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
