I am working with Sharepoint Server 2007 and have an external SQL Server database with two tables: master (<500 records) and detail (4 000 000+ records).
Of course in this case I should use the Business Data Catalog but I can't find any best practice for master-detail or other generic implementations using the BDC.
Where can I find this information?