| How to link tables in Visual Integrator |
Resolution | - Open Visual Integrator, Main, Export Job Maintenance
- Open or Create Export Job
- Click Link button on Configuration tab
- All Key Fields of Link Table Name must exist in Primary Table Name to create a proper link
- Key fields can be determined by examining File Layouts under Resources on the Sage 100 Desktop
- Enter a Sequence Number
- 00 can be used if table is not already linked
- Create an expression using all Key fields of Link Table Name separated by +
- Example: ARDivisionNo+CustomerNo
|
|