We have on-prem setup with Sql server as backend. I was trying to find out a lookup table or a key reference between an entity B (which is getting generalize from Entity A) & Entity A but didn’t find anything. However, On mendix side, I do see Xpath is pulling data based on referencing ID between 2 tables. I need to know Sql server side relationships in order to generate reports etc. Please let me know What I could be missing here.
B and A have the same value for id. So that is the link. Table A has a last attribute ‘submetaobjectname’ containing the entity name to which it is specialized.