I'm having a devil of a time joining two tables for a BDC to be used as a Business Data field in a list. I've seen plently of examplesÃÂ connecting two tables to use with web parts, however i haven't seen anything about using an association in a list. Before i continue to beat myself up i need to know that this is possible.
If that's confusing here's what i'm trying to do.
I have two tables Locations and Region. I need the Region_Name from the region table based on the Location_Id (primary key) from the Location table. Locations is connected to Region by Region_id as a foreign key.
Any help would be immensely appreciated.
View Complete Post