We would like to achieve this functionality: for each order we want to associate a store and a time slot in which the product can be collected.
We also like to manage the stores and the slots available for each store in the cms (for example adding the slots to a store like you add users to a group in windows)
What would be the best way to achieve this? Storing objects in Business Foundation or dynamic data storage, or is it better to have a custom database and admin tool?
Examples or pointers to the right direction are welcome :-)
Ok we found that it is possible to store the data with custom entities using Business Foundation.
The only problem is that a many to many relationship does not seem to work as we would like it to work.A "store" can have many "time slots" (in which orders can be collected) and a "time slot" can be used in many "stores".
So we would like to show an editable list of slots on the edit store Form. It could look like this:http://msdn.microsoft.com/en-us/library/Aa167285.405riordan1%28l=en-us,v=office.11%29.jpg
What would be the best way to achieve this?