Script to import records and add data / account number on import
I'm creating a database to manage a users stock portfolio that has multiple accounts but want's to be able to see their entire portfolio across all accounts in one place. I have an accounts table that just has a primary key_id for the account and the account number. I also have a table to import all of the transaction data into that has the buy sell information as well as a place for the Account foreign key.
I would like to create a script that helps the user to import the transaction data and also be able to add the foreign key by selecting which account the import is from.