2. ASPRunnerPro General questions
  3. [SOLVED]  Add values on the fly question
This topic is locked
[SOLVED]

 Add values on the fly question

 		1/21/2011 10:28:03 AM
ASPRunnerPro General questions
G
 GerryT author

On my add page I selected add values on the fly which works fine, it adds the little add to the right of the drop down and lets me add any value I want.
My question is when I go to the list page it displays a tab for the table that it was using the add value on the fly for. I do not want this to be displayed but if i do not select the table in the project, it will not show the add function to add the values on the fly. Same thing happens if i setup permissions for a username not to be able to do anything but add to that table. I also do not want it to display on the menu.
any suggestions?
Sergey Kornilov admin 1/21/2011

Proceed to Visual Editor->Menu builder and remove that item from the menu.
G
 		GerryT author 1/21/2011

Thank You.
another question,
example: i have a field called email address it looks up from email_address and then has the add value on the fly. I click add and input an email address that is already in that table, how can i have it display a message to the user that the email address is a duplicate. I am not sure what I need to do so i can validate if it is a duplicate entry.
Sergey Kornilov admin 1/21/2011

'Unique values' means do not show duplicate values and has nothing to do with adding new records.
If you need to prevent adding duplicate email addresses add BeforeAdd event to lookup table and use sample action 'Check if record exists'.
G
 		GerryT author 1/21/2011



'Unique values' means do not show duplicate values and has nothing to do with adding new records.
If you need to prevent adding duplicate email addresses add BeforeAdd event to lookup table and use sample action 'Check if record exists'.


Thanks! you can close this as solved