Lead Routing Possible?

[RL96]

Hello, Im looking for a solution to my request form routing. 

Is there a way to create a new table in a base for form requests, where I can approve a form and it will automatically link to the main projects table in the same base?

[Karlstens]

Being a little light on details, the short answer to this question is yes, there is a way - but how you'll achieve this, and why you're needing it setup this way will govern the best solution.

How many data points are you collecting? What field types are in the forms? Does the data collected need to be parsed or formatted? What type of form are you using, the Table View Form, or the Interface Form?