one to many relationship

[Animetal]

I´m trying to get a relationship one to many using the Sugar module builder. I need to do this:

One account can have many order numbers
One order number can have only one account

Just the way how the module CASE work on sugar

When I build the module and select the relationship relate to: account i can add many accounts to one order number

I tried avoiding make relationships and use the fileds option relate to: account but I cant find then the subpanel order number in the account module, right now im trying with flex relate but im not sure how that option works.

Thanks for your time

[dpatech]

What you need to do is add a "relate" field for "account_name" to your module. This adds an "account_id" field to your module. When Sugar sees a "relate" field it will add the "SELECT" and "CLEAR" buttons next to the field in your Edit View so you can select the appropriate account. Because you are storing just one account_id per record you get a one-to-many relationship. You can then (manually) define a sub-panel for Accounts to show the related records from your module.

[ptemplin7]

Also remember to implement the required vardefs and php fixes documented in the Wiki. It has a great step by step process. But if you don't do this you will be sorry. Look for blnak screens like I have. Still fixing the vardefs.

see here:
http://www.sugarcrm.com/wiki/index.p...s_in_Sugar_5.0

Note make sure any relate fields are set correctly. Including 1-1!

Paris

[DragonflyMaster]

Hi,

I think you'd find this helpful:
http://www.sugarcrm.com/forums/showthread.php?t=28679

[Animetal]

Thanks for those links, now i can learn more about how to work with my new modules.

Now after playing with sugar a while I found the module case do almost everything what i want, but i cant find the way how to edit it without changing the main code of the module. What i want is really simple, once you create a case you cant change the case to another account. If I give permission none to Edit in Case I cant create a new Case and if i go to account I still can add Cases to that Account.

Thanks for your support

Raul