how to Create 3 field with relationship?

[doulakis]

Hello,
I need to create 3 new field in create acount sugar form.
price,country and network.
The price is the price for my product per network per country.
Each price corresponds to one network/country.


How can i create this relationships in sugar?

In essence I need to create one row per price that contain:
Price (text field), Country (Drop Down List that contains all the countries) and Network (drop down list that contains all the networks of the Country).

For example i have one customer (account) with this prices:
Pirce: 0,3E, Country: Greece, Network:Vodafone
Price2:0,4E Country:USA, Network:AT&T

Can you Help me please?

Thanks guys!
You are the best!

[rafael.q.g@hotmail.com]

A solution could be:
1. Create a custom module
2. include fields: price, Country, and Network.
3. Customize this module layouts to display these 3 fields;
4. Create a relationship one-to-many from accounts to this new module.

Now from accounts you can create multiple records with these 3 fields.

[doulakis]

Thank you for your reply my friend.
If i have some other Question can i ask you again?

Best Regards.