Which custom object type should I use? | Community
Skip to main content
Kim_Gandy1
New Participant
December 1, 2017
Solved

Which custom object type should I use?

  • December 1, 2017
  • 1 reply
  • 4187 views

I'm working to import individual's product purchases.

Custom object: Purchase

Fields: Product, price, date purchased

Would this be a one-to-many or many-to-many custom object? Also, what field would be the link?

Best answer by SanfordWhiteman

Strive to avoid many-to-many (2nd-level) custom objects because they are not available from Velocity.

Unless you have a need to separately maintain Product metadata (characteristics other than purchase price, which is more a property of the purchase than of the product) then just use a 1st-level Purchase CO.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
December 1, 2017

Strive to avoid many-to-many (2nd-level) custom objects because they are not available from Velocity.

Unless you have a need to separately maintain Product metadata (characteristics other than purchase price, which is more a property of the purchase than of the product) then just use a 1st-level Purchase CO.

Kim_Gandy1
New Participant
December 1, 2017

To clarify, when you say "1st-level" you mean one-to-many, correct? Thanks @Sanford Whiteman​!

SanfordWhiteman
New Participant
December 1, 2017

Yes.