We use SQL server. How do I link the primary and foreign keys to multiple tables to bring in data in to a form? The training video only showed one table(customers) that was used to demo. Thank you.
We use SQL server. How do I link the primary and foreign keys to multiple tables to bring in data in to a form? The training video only showed one table(customers) that was used to demo. Thank you.
I think that you are asking how to integrate with multiple tables in SQL. If this is the case, please review our help guide on configuring the Connection Agent: http://www.perfectforms.com/Documentation/manual/html/?configuring_the_lookup_agent.htm, and creating new connections: http://www.perfectforms.com/Documentation/manual/html/?general_approach_to_integratio.htm.