There are a few ways to work with multiple tables in the Easy SQL plug-in, depending on what you want to do with the tables.
|Joining multiple tables||The most common means of using secondary tables is to join them to your main table.|
|Lookup restrictions||Often, you’ll have a lookup table and you need to get only the records that match some field in that lookup table.|
|Match lookup||Sometimes you’ll need to look up some info in another table based on a value that you have.|
|Multiple Choice||If a column in your table must contain a value from another table, that’s a foreign key. If you tell the plug-in about that foreign key, it will automatically display a checkbox, radio button, or pull-down menu in forms as appropriate.|
|Switching tables||If you need to display completely unrelated data on the same page, you can switch tables.|