Thank you.
>There are a couple of things going on.
>
>First, you have an FK to some lookup value. You can easily get that using Viv's suggestions.
>
>Second, you need a picklist in a dropdown to select the value from when you create or edit. Putting the SelectList in the ViewModel as I suggested is the best way to go with that.
>
>
>>The only thing is set in the database, as far as relationship, is Foreign Key Constraint for the field Reference in ReferenceCode table and the same field name (Reference) in the Orders table. And I don't know if this is the "relationship" that is needed for EF or there is something other than that.
>>Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
