B4J Question List with Multiple fields

[aaronk]

Hi,

I am trying to create a list but have multiple columns.

I tried using a map (I might of done it wrong) but can't work out how to use multiple columns.

I need to have the following fields in a list..
AccountID
Field1
Field2
Field3

I want AccountID to be unique. So if the value of AccountID is already added in the list then it should not add the item to the list again.

I need to be able to select Field1, Field2 & Field3 based on the accountID value.

Any ideas on what I need to do to create a list based on the fields above ?

 

[Erel]

You can use a Map where the keys are the AccountID and the values are a custom type with all other fields.

 

[aaronk]

Are you able to give me a example ?

I tried using the map but I could only work out how to add a key and only 1 value for that key.

 

[Erel]

Type MyDataType (AccountId As String, Field1 As String, Field2 As Int, Field3 As Double)

Sub AddItemToMap(AccountId As String, Field1 As String, Field2 As Int, Field3 As Double)
dim mt As MyDataType
mt.Initialize
mt.AccountId = AccountId
mt.Field1 = Field1
...
map.Put(AccountId, mt)
End Sub

Dim mt As MyDataType = map.Get("Some Id")