I have a view that lists On Board staff members. Now each staff have a contract and its renewed every year.
How can I let my new form to pickup the values stored in selected view row and store in the new form I'm creating. To make it more clear, the view lists ID #, Last Name, First Name for each staff on board. The view have a button called CREATE NEW CONTRACT, now the user will select a staff name, then click that button, the new form ( Contract ) should take ID #, Last Name, First Name and store them in its fields.
I saw it in some datababases, so I know it's possible.
Any help would be appreciated.