Multiple Tables
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. |