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.
Any ideas on how to do this?