The product looks great, and I've created a trial account to see if it will work for me, but can't figure out how I might achieve what I want. My needs (I think!) are a pretty standard business setup...

The setup (Capitalised items are Fusioo "Apps", and the n:n are "App Relationships" that I already have configured and working):

- Company has 0:many Contact
- Company has 0:many Invoice
- Invoice has 1:many LineItem
- LineItem has 1 Product

The question:

I would like to ask Fusioo which contacts have access to product X. (And by ask I mean show in a view, or search/query results) It seems that the "App Relationships" reference links go only 1 relationship deep, but I think I need 2 or 3 deep (ie. Show on LineItem not just the Invoice fields, but the Invoice->Company, or even better the Invoice->Company->Contact(s) fields). I've tried to see if I can create workflows to copy the data around the Apps but can't quite figure it out, and it seems like the wrong approach in this instance anyway since I'll have crazy duplication at multiple levels.

How can I achieve this? (Any feedback appreciated - Thanks!)