Thanks Nitai! That kinda makes sense. So for example, say I had a database of aircraft classified ads that used 4 tables, with each table using the unique ID column "classified_id" (found in the main table) as the primary key/foreign key to relate all the tables together.
main table details table features table photos table Using CFINDEX, I would create a collection, called "aircraft classifieds". I would populate the key field with the "classified_id" and the body with all the relevant columns from ALL the tables. If a search matched any of those fields, it would return the KEY, which is the classified_ID, and I could then go fetch the actual records using that classified_id. Is that about right? --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
