Any Method to check within a record for 'not null' options?

2011-08-28 Thread Shiju John
Hi, I have a generic issue. The issue is as described below: I have a form which stores 20 questions. These questions are not mandatory, and the user might answer any n questions out of this 20. I need to do a customization such that i need only the questions answered to be pushed to a new

Re: Any Method to check within a record for 'not null' options?

2011-08-28 Thread JD Hood
John, If there is some user interaction that occurs as the result of each answer pushed before the entire record is saved, then active-links are appropriate -- even if you have to build one per question. If there is no user interaction that occurs from each push, then I would post-pone the push

Re: Any Method to check within a record for 'not null' options?

2011-08-28 Thread Shiju John
Hi Hood, Thanks for your response. Just a little bit more elaboration on the issue. Just consider it as a checklist instead of the questions, for better understanding :). Some options would be irrelevant based on the application/release. In that case user wont be answering the respective question.

Re: Print Results in 18 copies

2011-08-28 Thread Randy Evans
We got this when we upgraded to WIN7, it was completely random but always 18 copies. What we did was to send the report to the screen then if the user prints from Crystal it comes out OK. On 8/26/2011 12:03 PM, Andre Hughes wrote: I know this may be a time consuming work around. However, you

Re: Any Method to check within a record for 'not null' options?

2011-08-28 Thread JD Hood
If I understand what you want to do, there are different ways of reaching your goal and opinions will vary on which is the best design. Perhaps the simplest would be via table-field that reads from your questions form with workflow to record (push) answers to wherever you like. So, it sounds like

Re: Any Method to check within a record for 'not null' options?

2011-08-28 Thread Doug Blair
** Hi...A subject dear to my heart! See my presentation called QandA from the 2004 BMCUW in DC!I would do this with three forms and a join form. A form containing questions (and for more elaborate scenarios, a flag for the type of expected answer: integer, character, yes/no, date etc) A form

Re: Any Method to check within a record for 'not null' options?

2011-08-28 Thread Chintan Shah
Hi John, I had a similar scenario to work with in past. Let me share the solution with you and list. I am assuming that users will answer data in character field.  There should be 3 forms in total a) UI form. b) Questions form c) Transactional Form(copy of questions form+a character field to