To clarify. The reason I'm asking is that I need to loop and insert all items in a table to create a tree. So it would have to start with the first item in the list to get an ID for the second item.
>Brain Meltdown. Maybe someone can help. I have a list such as (item1,item2,item3,item4,item5). The list can be any length. Item1 would be the parent of item2 and item2 would be the parent of item3 and so on. What's the most efficient way of determining the parent of any item in the list and determining that item1 has no parent? Thanks, Emmet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208360 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