hi,
Suppose I have 3 related tables
Cat (CatID, CatName)
item (ItemID, ItemName, CatID)
Invoice (InvoiceID, ItemID)
Is it possible to create an entity InvoiceEntity that have
(InvoiceID,ItemID, ItemName, CatID, CatName)
where ItemName, CatID, CatName are FieldsOnRelatedFields
(The problem is in CatName)