tero_takala's avatar
tero_takala
New Member
5 years ago
Status:
Needs Votes

Enhanced Model view

With multiple tables in the model view, the relationship jungle can become a bit overwhelming. Especially, if you need to debug an error in the dataset (say, tables are linked by fields where one table has a certain value that is missing from the other table). For this reason, it would be extremely useful to have a "split view" (upper and lower part) in the model view. The upper part would show the relationships exactly the way they are shown in the model view right now. The lower part would show you the tables you select from the upper part and highlight the columns in tables that are used in the relationship. Filtering options should be made available for all tables separately so that debugging complicated errors becomes easier. If you want to develop this further, you could also add similar functionality to cover "relationships" that are done by using LOOKUPVALUE function.

Recent ideas