So I'm a complete noob to Dynamic Data. My team set up a Dynamic Data website which we're essentially using for scaffolding...we have an already existing DB schema which we plugged it into. And it works perfectly!
One thing though - the Dynamic Data code automatically infers a friendly name when generating a drop down list for a foreign key. In our case, we have a "Contacts" table, and the primary key is ContactID, and the first field in the table is "First_Name", and this is what is showing up in the drop down menu. So for instance, when adding or editing an entry in our "Entry" table, it has a foreign key which points to the Contacts table, and it automatically generates a drop down list which friendly names that it has inferred. But the friendly name it picked was the "First_Name" column of the Contact table...which isn't so helpful. For a contact name, you'd probably want first name + last name and maybe even add the company name as well.
So how do I change the site and/or data model so that when it creates a drop downlist as a foreign key relationship from my Contacts table, it concatenates the first name and last name columns instead of just displaying the first name column?
Thanks!