Is there a way to make a collection of say "Insurance Types", and in another collection, set a column to be a "look-up" column where those insurance types would be listed where you could then select one or more insurance types from that table?
-
Tommy Thomas
- Posts: 0
- Joined: Thu Mar 06, 2014 3:44 pm
-
Maryna Brodina
- Posts: 0
- Joined: Thu Apr 05, 2012 7:27 am
Look-Up Tables
Hello! If you make this column a pointer, you'll be able to add only one pointer. In this case you'll be able to get data from main and dependent tables ("Insurance Types") per one request. If this column would have object or array type, you can store in this column a few links to "Insurance Types" table, but you would need to do 2 requests to DB to get data.