How to organize your tables and questions about relations
Posted: Thu Sep 22, 2016 12:42 am
I have a TON of tables in my dictionary and I'm trying to simplify things for the user by organizing them in some way. I was hoping there was a way I could group them, like in folders. My first attempt was to put each in a different data source, which worked nicely in the dictionary but when you add a text item they aren't organized by data source anymore.
Now I'm looking at relations to see if they'll work for what I need. Here are the questions I have:
1. Are they 1 data row to 1 data row relations only, or could I have a relation with multiple rows? For example, say I have a table called Children and another called Toys and I want to group Toys under Children. Since every child might own more than one toy, can I have a Children to Toys relation where there are multiple toys?
2. If I can have multiple rows in a relation, is there a way to loop through just the relations in something like a data band? When I create a data band it doesn't seem like I can select a relation and thus I loop through every Child instead of every Toy that one child owns.
3. With relations, can I hide the tables somehow outside the relations so they aren't visible in my list of tables twice (once as their own table and once as a relation)?
4. Is there a way to add relations in the JSON file that I pass to dataSet.readJson()?
5. Is this the best way to organize data tables for the user or is there another way?
Thanks so much!
Now I'm looking at relations to see if they'll work for what I need. Here are the questions I have:
1. Are they 1 data row to 1 data row relations only, or could I have a relation with multiple rows? For example, say I have a table called Children and another called Toys and I want to group Toys under Children. Since every child might own more than one toy, can I have a Children to Toys relation where there are multiple toys?
2. If I can have multiple rows in a relation, is there a way to loop through just the relations in something like a data band? When I create a data band it doesn't seem like I can select a relation and thus I loop through every Child instead of every Toy that one child owns.
3. With relations, can I hide the tables somehow outside the relations so they aren't visible in my list of tables twice (once as their own table and once as a relation)?
4. Is there a way to add relations in the JSON file that I pass to dataSet.readJson()?
5. Is this the best way to organize data tables for the user or is there another way?
Thanks so much!