Posting the same question under three different subjects won't get your question answered any quicker.
Flash is perfectly capable of CRUD communication with a database and displaying it however you like. You're asking for advice on how to set up a relational database and how to write inner join SQL statements, and then how to send that data to Flash. Only one part of that has anything to do with Flash, and it's probably one of the most basic things you can do with Flash (displaying data). I suggest you buy an introduction to Flash book and an introduction to relational database book and get to reading. _______________________________________________ Flashcoders@chattyfig.figleaf.com To change your subscription options or search the archive: http://chattyfig.figleaf.com/mailman/listinfo/flashcoders Brought to you by Fig Leaf Software Premier Authorized Adobe Consulting and Training http://www.figleaf.com http://training.figleaf.com