Build a form from one table in another table.

[stevelucky]

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.

Any thoughts?

[efen]

Why have you started a new thread on the same topic as your other post?

http://fmforums.com/forum/showtopic.php?tid/214006/

[stevelucky]

I thought this one would be a little more clear as to where I'm at now and what I'm trying to accomplish. Sorry for any confusion.

[efen]

Then why didn't you add the post to the end of the other thread?

Anyone trying to follow this topic sees that it is not resolved in your first post but would not be aware that it continues in another thread (and may be answered there).