llblgen version 2.0 dotnet framework 2.0

Here are my database table relationships: ClaimBill.ProviderId - Provider.Id (m:n relationship) ClaimBill.PpoProviderId - Provider.Id (m:n relationship)

I need to create a ClaimBillTypedList that has the Provider.Name, Provider.TaxId, and Provider.Address for both the Provider and PpoProvider that belongs to the ClaimBill. Using code generator, I can create a ClaimBillTypedList. I can specify the detail provider information that I need such as Provider.TaxId, Provider.Address, and Provider.Name.

Questions: 1. How do I, through the code generator, retrieve detail Provider Information for both ClaimBill.Provider and ClaimBill.PpoProvider? 2. Since the code generator allows me to specify that I want to retrieve the Provider.Name, Provider.TaxId, and Provider.Address, which path does it take (through the Provider relationship or through the PpoProvider relationship)?

Thanks,

BZ

ClaimBill.ProviderId - Provider.Id (m:n relationship) ClaimBill.PpoProviderId - Provider.Id (m:n relationship)

Are you sure the above are m:n relations or m:1 relations?

Questions: 1. How do I, through the code generator, retrieve detail Provider Information for both ClaimBill.Provider and ClaimBill.PpoProvider? 2. Since the code generator allows me to specify that I want to retrieve the Provider.Name, Provider.TaxId, and Provider.Address, which path does it take (through the Provider relationship or through the PpoProvider relationship)?

From the Designer when you add the Provider Entity to the TypedList, you have the option to choose which relation/path to be used for this entity. (Just below the Entities Added List, there is a section for the Relations Used. And there is a dropdownList to Select Alternative Relation).

You may also Add the same entity more than once to the TypedList, each with a different Relation being selected. And in the Entities Added List, there is a column where you can specify an Alias for each added Entity.