PerfectForms Forums Topic: create look-up table

PerfectForms Forums Topic: create look-up table http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Wed, 08 Feb 2012 04:17:02 +0000 capson on "create look-up table" http://www.perfectforms.com/forums/topic/create-look-up-table#post-1109 Thu, 04 Feb 2010 13:23:40 +0000 capson 1109@http://www.perfectforms.com/forums/ Thank you ajobling on "create look-up table" http://www.perfectforms.com/forums/topic/create-look-up-table#post-1108 Wed, 03 Feb 2010 13:59:48 +0000 ajobling 1108@http://www.perfectforms.com/forums/ If you are using option 1 - Database Table, then in the Action you can select the 'Distinct Values Only' option. If you are using option 2 - Form Connection, then it is not possible. capson on "create look-up table" http://www.perfectforms.com/forums/topic/create-look-up-table#post-1107 Wed, 03 Feb 2010 12:44:52 +0000 capson 1107@http://www.perfectforms.com/forums/ Or allow only allow unique entries capson on "create look-up table" http://www.perfectforms.com/forums/topic/create-look-up-table#post-1106 Wed, 03 Feb 2010 12:32:47 +0000 capson 1106@http://www.perfectforms.com/forums/ Is there a way to de-duplicate the table, I have looked but cant come up with away to do so. Thanks ajobling on "create look-up table" http://www.perfectforms.com/forums/topic/create-look-up-table#post-1047 Tue, 05 Jan 2010 10:21:17 +0000 ajobling 1047@http://www.perfectforms.com/forums/ If you are looking to create a table (or more accurately a data-source) that can be used by other forms then there are two methods that spring to mind. 1) Using a connection you can pass data from the five different forms into a single database table and use that table as the data-source for other forms or 2) You can have another PerfectForms form which acts as the data-source. Use a 'Form Connection / Insert Action' to pass data from the five different forms into this single form, and then use this single form as the data-source. capson on "create look-up table" http://www.perfectforms.com/forums/topic/create-look-up-table#post-1046 Wed, 30 Dec 2009 01:17:20 +0000 capson 1046@http://www.perfectforms.com/forums/ Hello, If I have, say 5 different forms(not instances)and each form has collected contact information: Name, email address, job title, etc.... I want to create an underlying table (not a form table) with the collected customer information to use as a look-up table for a new form. Not sure how to do this in P.F, i.e how to create a table with this information from 5 different tables. Hope I was clear, thanks