>>>You need to use adbObject(aRel, "Relation") and go from there. The array will contain all the foreign keys.
>>
>>Hi Dragan,
>>
>>Heresy of heresies! The relations are not present in the DBC. For better or for worse. The ProMatrix framework handles them all.
>
>Um... yes, that was 20 years ago, and I inherited an app done in then VPM... I guess most of the code back then was just a port from FPD. It's a miracle that it worked as it did (5.1 or 5.2 or something), and of course the guys who did the app got most of the things wrong, so I also had to fight the framework instead of using it, half of the time at least. No wonder I never learned to like it :).
>
>So I guess the VPM's DD is something that existed before VFP and dbc, right?

Yes, before it became Visual ProMatrix. The original framework has at least one method named the same as a method in Yag's freebie framework (which was distributed as part of the FP back in the day, IIRC). And I was told that someone other than the ProMatrix principles wrote that framework, but the name was never disclosed and I don't know it. That said, it was extensible and accounted for data/action trigger needs beyond what the DBC did, so that turned out for the best. That's why I chose it (back in 95): extensibility, aimed toward attribute-driven development wherever possible.

Time moves on, how we do things changes, and some ideas last. Lianja has programmable metadata (json) attached to tables, fields, view, database. Some of it integrates (developer option) directly with the UI, giving uniformity with exceptions as wanted, throughout an application. The developer can have other information there, readable at runtime, for doing whatever.

Hank