Mysql and global fields
I use filemaker pro with a Mysql backend
In a form i need to make a filtered lookup list from another file.
Normally i do this with a relation and a global field (to filter the list)
But with mysql i cant use a global field
does anyone know a solution for this problem ???
Example : I have a table Products
I have a table with clients and suppliers
In the lookup field in the form products i want only get the suppliers from the table ??