Wayne, What version of FM? It may be that you need to have a TABLE OCCURRENCE name and not layout name (unless that IS the correctly name TO). Or you don't need to specify the TO with the field. Check the xDBC guide for FM for correct syntax.
NEI (not enough information), Beverly On 30 Mar 2011, at 2:16 AM, Wayne Irvine wrote: > Many moons ago we came up with something of a hack to meet the needs > of a client. The client is an association of companies in the > photographic industry whose members supply a range of photographic > and photography related products. > > http://www.photoimaging.com.au/ > > One link allows you to search by type of product and brand: > > http://www.photoimaging.com.au/Members/memberssearch.taf > > Each value in the drop down is a field name in the db. These fields > contains the brands the member distributes. So if you select > 'Cameras' and enter 'canon' it searches the field 'cameras' for the > value 'canon' and returns a list of distributors. > > The search criteria looks like this: > > > <Screen shot 2011-03-30 at 5.12.04 PM.png> > > The same code doesn't work in 6. It returns the error: > > [FileMaker][FileMaker JDBC] FQL0007/(1:40): The column named > "L1.cameras" does not exist in any table in the column reference's > scope. > > Weird thing is, it's getting the field name correct but not the > table name. > > Any ideas how to get around this or should a rewrite the db. > > Wayne > > To unsubscribe from this list, please send an email to [email protected] > with "unsubscribe witango-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
