Kevin, What are the original sources of this view and the vendor form?? Are they both database tables or views??? If so you can create a database view that is a join view of both those tables/views and take it from there. If one or both of the tables is not a database table or view, then creating a join would not be possible. You would need to create a staging table that would contain all the data from that source before you can do anything.. Joe
----- Original Message ---- From: Kevin Pulsen <[EMAIL PROTECTED]> To: [email protected] Sent: Tuesday, June 3, 2008 1:12:00 PM Subject: View and Vendor forms not allowed in Join Forms ** Good morning all, I was hoping not to create extra forms and workflow... but I have 1 View form and 1 Vendor form.. I need to combine the data from both, however can't use either in a join form. Any ideas on what would work best, without creating 2 new staging forms, extra workflow to create a join of the data? Thanks, Kevin P. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
