Steve, I will admit that I thought about a view in this case, however the actual table will hold other fields of information as well that is not contained in either table or any other table.
But after thinking about it some more, I think adding these to the actual items table might be the way to go and use the view as first thought, and go with your suggestion of a view. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
