AnsweredAssumed Answered

Relationship between 5 modules

Question asked by Diego Vasciarelli on Mar 5, 2018
Latest reply on Mar 6, 2018 by Francesca Shiekh

Like • Show 0 Likes0
Comment • 3

Hi,

i have a business case, based on 4 custom modules. The products can be placed on a depot/warehouse but, optionally, we can specify the location inside the depot, and the bin. I created the following relationships:

Account *1toM* Warehouse *1toM* Locations *1toM* Bins *1toM* Products

Warehouse *1toM* Products

Account *1toM* Products

I want to see in "Warehouse" the products products related to bins and locations related to the warehouse.

Is there a simple way to keep align the relationship between products, warehouse and account?

Thanks,

Diego

No one else has this question

Outcomes

3 Replies

Rolustech Support Mar 6, 2018 2:06 AM
Mark Correct
Correct Answer
Hi Diego Vasciarelli,

Instead of creating additional relationships keep your metadata simple and use function based subpanels to show data on the basis of custom query (read only).

Kind Regards,
Rolustech Support
Email: support@rolustech.com
Website: www.rolustech.com
Like • Show 1 Like1
Actions
Prashant Patel Mar 6, 2018 5:36 AM
Mark Correct
Correct Answer
Hello Diego Vasciarelli,

You can create a subpanel which doesn't need module and just show the data from tables using query.
This link will be useful for you.
SugarCRM 7 - Custom subpanels

Thanks
Prashant
Like • Show 1 Like1
Actions
- Francesca Shiekh @ Prashant Patel on Mar 6, 2018 8:58 AM
  Mark Correct
  Correct Answer
  Just beware that in that post Shane uses joinRaw which has been deprecated some time ago and removed in 7.9
  See:
  What to use instead of joinRaw in anticipation of 7.9 removing the method?
  
  HTH,
  FrancescaS
  1 person found this helpful
  Like • Show 1 Like1
  Actions

Relationship between 5 modules

Outcomes

Related Content

Recommended Content