Multiple Destination Form

[austinr]

Currently I have three separate forms that correspond to three separate tables. The three tables cannot be combined. Is there a way to have a form write information to multiple tables depending on the field? Any help is appreciated. Thanks.

 

[Banana]

Wouldn't subforms work for you?

 

[austinr]

Thanks, I'll look into it.