I am working on a project. Here I have three tables with some fields common to each table.
I am attaching a sheet which will give u an idea on the structure of these tables.
What I need to do is:
Step1. Join table 1 & table 2 with Ano as the common field. Name this table as Table X
Step2. Add a calculated field in TableX which is a concatenation of : customer, cartidge, city, state. Name the field as KEY
Step3. Add a calculated field in Table3 which is a concatenation of CUSTOMER_NAME, Product Number,Ship City, ShipState. Name the field as KEY
Step4. Join Table X and Table 3 with KEY as common field. The final table structure (FInal Output) is shown in attached sheet.