Page 1 of 1

Look-Up Tables

Posted: Thu Mar 06, 2014 3:44 pm
by Tommy Thomas

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?


Look-Up Tables

Posted: Thu Mar 06, 2014 4:36 pm
by Maryna Brodina

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.