Re: View and Vendor forms not allowed in Join Forms
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: arslist@ARSLIST.ORG 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"
Re: View and Vendor forms not allowed in Join Forms
Since nobody else has responded, I'll just go ahead and tell you. I have good news and bad news. The good news is that you don't have to create two new staging forms. The bad news is that you probably still have to create at least one regular form where both have escalations writing data to. Sorry, Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Pulsen Sent: Tuesday, June 03, 2008 12:12 PM To: arslist@ARSLIST.ORG 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. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
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"