Using this information could I ask if anyone could show me what the script would be to get the correct results. I am trying to take information from two tables that have a common ID number. When they match to create a new record in a third table.
I have 3 tables:
Accountproduct
Contract
ContractItem
Main Fields in tables:
In Accountproduct we have AccountProductID, accountID, userfield10
In Contract we have AccountID, userfield1
In ContractItem we have ContractitemID, ContractID, AccountProductID
I imported Accountproduct and contract into database. I have a matching ID number that was imported into each table that match the product and contract together. In the AccountProduct the ID number was imported into "userfield10" and for the Contract it was imported into "userfield1"
I am trying to do a join to match the records of the ID number. Then when a match is made it adds a record to the ContractItem table. I also need to make a random number for the ContractItem field "contractitemID
I have 3 tables:
Accountproduct
Contract
ContractItem
Main Fields in tables:
In Accountproduct we have AccountProductID, accountID, userfield10
In Contract we have AccountID, userfield1
In ContractItem we have ContractitemID, ContractID, AccountProductID
I imported Accountproduct and contract into database. I have a matching ID number that was imported into each table that match the product and contract together. In the AccountProduct the ID number was imported into "userfield10" and for the Contract it was imported into "userfield1"
I am trying to do a join to match the records of the ID number. Then when a match is made it adds a record to the ContractItem table. I also need to make a random number for the ContractItem field "contractitemID