So needs some help please.....
So in my FM data base I want to enter in our job number and have it look up information from our ERP system and populate some basic information like;
Customer Name
CSR
SalesPerson
ETC.
(Based on us putting in the job number.) Although I'm not sure how putting in number and having it populate multiple other fields is the trick?
Most information is looked up via ODBC data connection via OpenJob table. However in OpenJob I have customer# and will need to link our Customer table to OpenJob to get the Name of the Customer.
Can someone help please??
Example
Table: OpenJob - IN ERP
JobN-99999
Customer Number: 1212
CSR # 111
Table: Customer - IN ERP
Customer Name: ABC Company
Customer Number: 1212
Table: CSR - IN ERP
CSR Name: Jane Doe
CSR # 111
Table: Filemaker
JobN:
Customer Name:
CSR Name:
SalesPerson Name:
Job# 99999 (the lookup from ERP System via odbc connection and poputate)
Customer Name: ABC Company
CSR: Jane Doe
SalesPerson: John Smith
Any help would be greatly appreiated
Thanks
Cory
