Multiple Tables

austinl · Post by **austinl** » Tue Jun 24, 2014 6:06 pm

I am trying to combine 7 tables with similar into one table so I can use it as a order list. Is there any way to do this or to use multiple tables in the look-up? I basically have 7 tables with different products and I need to be able to select from all 7 with a drop-down list in my order table.

mobhar · Post by **mobhar** » Tue Jun 24, 2014 7:06 pm

Just combine all 7 tables into one Database View, then simply use that Database View as the lookup table for your desired field.

austinl · Post by **austinl** » Tue Jun 24, 2014 8:19 pm

How do I do this? Is it a custom SQL command?

mobhar · Post by **mobhar** » Tue Jun 24, 2014 10:06 pm

It depends on how the schema of those your 7 tables.

Basically, if their schema are similar, then you may use UNION to combine all the data from those 7 tables into one Database View.