General information
Category:
The Mere Mortals .NET Framework
Title:
Entity from multiple tables
Hi,
Using MM.NET 4.0, classic entities (not Entity Framework).
Here is the problem I'm trying to solve... I want a lookup list for some objects in a child table, but I want a field from the parent table to display in the list. The best example I can think of is a customer with invoices. (That's not what I'm really working with but this simple example will do.)
Imagine a customer table (custPK, custName, blah, blah, blah)
And an invoice table (invPK, custFK, item, Qty, Amt)
I want an entity list of invoices (for look up purposes only) that contains:
( invPK, custName, Item, Qty, Amt )
Note the custName field comes from another table other than the primary entity.
I have been using mmBindingList for creating lookups and lists of single-table entities and this has worked well.
But how do I grab a field from another table? I tried to use the BLG to create a new entity for this purpose but unless I'm missing something, it can only create custom entities from a single table.
Any ideas?
Thanks,
Guy
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only