This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at email@example.com
Greetings, I'm using LS 5.0.2302. I've attempted to model the following relationship:
The primary key on ProductNames is the composite of Id and Language Id.
I read this Article and think i did what it said.
I'm getting this error when trying to access product.ProductNames
I'm not sure how to resolve. Any thoughts?
The FK must be of the same type as the target PK and not part of a composite key so unfortunately this is not possible with LightSpeed. You can workaround this if you model it without the relationship being directly enforced within LightSpeed but still maintain the FK in the database to preserve referential integrity.