I have an existing DB2 database I have to work with, they have many tables where the "key" is the combination of one or more fields. How can I accommodate this design using SF?



The BO mapper lets me define multiple fields as primary keys via "Override Primary Key Specification", it then shows them as FIELD1,FIELD2. It is going to use the concatenation of these two fields as the primary key?



If not I should just be able to control the assignment of the two key fields manually right? Its more work but I did it before as a work around before I got my auto incrementing key fields working.



Thanks.

Keith Chisarik

Also having problems with field names that have the # sign in them (FIELDNAME#), how might I fix that?



Project wont compile after partials are rebuilt due to these errors (too many to list).



Here is an example of one error:



Bracket identifier is missing closing ']' for:



'''

''' MNXSTYL#

'''

'''


BusinessFieldDisplayInEditor(), _

Description("MNXSTYL#"), _

DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _

Public Property [MNXSTYL#]() As System.Decimal

Get

Return CType(Me.CurrentRow.Item("MNXSTYL#"), System.Decimal)

End Get

Set(ByVal value As System.Decimal)

Me.CurrentRow.Item("MNXSTYL#") = value

End Set

End Property




Keith Chisarik