I'm not looking for complete models here, just the relationships. I've done the models all ready I also did the relationships that I thought would work. They don't work.
The bit I'm missing is how to have multiple costs that belong to the product via a lender. Then groups those costs and assign them to a person. On Dec 12, 4:34 pm, Nicholas Orr <[email protected]> wrote: > I should mention that when someone is creating a rate plan they'd do > the following. > > 1. Create rate plan (they don't give it a name or anything) > 2. Select a product from the products list > 3. Select a supplier from the supplier list > 4. Type in a cost for that product > lender combo > 5. Go to step 2 until done > 6. Save > > :) > > On Dec 12, 4:26 pm, "Nicholas Orr" <[email protected]> wrote: > > > Hi, > > > I have this data >http://files.nicholasorr.com/data.html > > > I need to model it. > > > I've come up with these models > > > Person > > Product > > Supplier > > RatePlan > > Cost > > > These are the questions & expected answers > > > Q: How much does john get beans for? > > A: acme => $2, nestle => $2.50, pinehurst => $2.25 > > > Q: What products does john have access to? > > A: beans, apples > > > Q: Who is on Rate 1? > > A: john, david > > > Q: What products does rate 3 have? > > A: beans, apples, oranges > > > Q: What suppliers are available? > > A: acme, nestle, pinehurst, smiths > > > Q: What products are available? > > A: beans, apples, oranges > > > This is the relationship I see > > > Person > RatePlan > Product > Lender > Cost > > > But I don't know how to setup the models so all the questions above > > are answered :/ > > > Looking forward to your suggestions :) > > > Thanks, > > > Nick --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---
