I would like a mini Flex app that has basic CRUD (Create Read Update Delete) functionality for the following form scenario:
U.S. State (combo box) - for this app, feel free to use just a dozen states if you want. I can fill the rest later.
The user fills out their name and selects their State and marks as many of the checkboxes that applies to their skillset.
Visually, I imagine a box down the left (1/3 of x space) with the names currently entered. These names can be edited or deleted via "edit" and "delete" buttons respectively.
A new name/record can be created with a "new" button.
On the right (2/3 of x space) is where individual records can be added or edited with a corresponding Save "button".
Lastly, there should be 2 filter combo boxes in the left box where the list of names is. The first combo box should be populated with the various languages including the default "All". The user can then choose to see only the names capable of a particular language. The selection should happen upon release over the language in the combo box. The second combo box is the list of states with the default "All". Selecting both combo boxes should have a cumulative effect.
I'm open to suggestions of functionality but this is the essence of what I need.
Standard Flex UI design is fine.
MySQL 5 Database is configured like this:
Table #1 - people
firstName, lastName, personID (Key), stateID (ForeignKey)
Table #2 - languages
language, languageID (Key)
Table #3 - peopleLanguages
personLanguageID (Key), personID (ForeignKey), languageID (ForeignKey)
Table #4 - states
state, stateID (Key)
(Note: I will reject any project that builds queries that don't work for this basic normalized structure.)
Use Flex 3 and Actionscript 3. The UI elements can be MXML, but I want the logic and data calls to be AS3.
I want Flex to communicate with a Coldfusion CFC via the RemoteObject class.
I don't want a hack, I want good OOP and Flex best practices.
Deliverables would be the Flex Application file and the Coldfusion CFC with the queries built into the CFC functions and the MySQL queries for building the database.
The Coldfusion datasource name should be "dsProgrammers".