I have configured a ODBC Connection (Microsoft SQL Server) in LEI. I have two tables and want to get these information in one notes form.
In table one are stored some working information and a field with the employee-number. In the second table are stored all employees (and also the employee-number).
I have an replication-activity that creates all documents from the first table in my notes-database.
How can I get the employee-names from the second table in my notesdocuments?
I have tried a second replication-activity with the target restriction to skip deletions and insertions, but every employee appears only one time.
I hope you understand my problem and excuse my english.