Build a form from one table in another table.
I have 2 tables. One is called "Reps" and the other is called "Accounts". The reps table contains general info for my salespeople. My "Accounts" table contains information about accounts that the salespeople have sold. One of the fields here is "Rep Name" which is a drop down that pulls directly from the "Rep Name' field in my "Reps" table.
I'd like to do 2 things:
1) I have a page with a form where I enter in all my rep info. This is on the left side of the page. I'd like to be able to put a form on the right side of the page where I can create new accounts. Ideally, it would know that the new account belongs to salesperson A because his record is up on the left side of the page.
2) Below the new account form, have a table that shows all of the accounts that the sales person has sold. So when I create a new account in the form, it will just get added to that last. Ideally, sorted newest to oldest.