Having a drop down menu select between multiple tables.
I apologize if this has been covered; I've been Googling for days and can't find exactly what I'm looking for.
I'm assuming I'm not using the proper terminology in my searches, so if this has been covered you can post a link and I'll take it from there.
I have multiple price lists from different manufacturers in different tables. I can't make one table since each manufacturer structures pricing differently.
I also have a table of the manufacturers. They are linked to their price lists via a common ID (ManuID).
Here's the scenario (using FMP12):
1- Drop down menu of Manufacturers
2- Drop down menu of price list SKU's
Can I make menu 1 change which table I'm using for menu 2?
I tried a calculation using Case, but to no avail.
Thank you in advance.