Hi Robert, If the relations are already defined in transfer's config file, you could just join them as you have done already:
TQL = "FROM inventory.Stock AS Stock JOIN order.item AS Item *JOIN order.order AS Order* WHERE Stock.StockNumber= :StockNumber" >From my experience, if there's only one possible relation that fits the JOIN, it'll be used. Have you tried this? What happened? Cheers, Pedro. -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search: http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en