View Full Version : PROBLEMS WITH DESIGNING


webryant
03-21-2000, 03:37 AM
QUESTION 1: I am designing a Form for people to fill-in and then I want them to be able to print a report base on the information they input. The parts of the Form are:
1. The person requesting information, name, address, company name, phone no etc and type of business (to choose from list).
2. Department name where information is kept (to choose from list)
3. Day, date, month, year when information issued.
4. Condition that must apply (tick box)
5. Entering a number beside items that are required. Various items may be selected.
I am having problems with the CONDITION Field:-
*I have a field called CONDITION (yes/no data type)
*The Condition will either apply or not apply
(The Condition has four items that must apply and each Condition may take up two lines.) Eg.
 No person ……………………..……………………..…………………….
i) gjgjgjgjgfgfg fgfgfg f g ffgfg fgfgfg f g ffgfg fgfgfg f g ffgfg fgfgfg f g ffgfg fgfgfg f g ffgfg fgfgfg f g f
ii) dfdjfjdjfjdfjdfj djfjdf djf g gofugfg ugfk g gofugfg ugfk g gofugfg ugfk g gofugfg iii) dfdjfjdjfjdfjdfj djfjdf djf
iv) dfdjfjdjfjdfjdfj djfjdf djf ppplpl
 On the Report I want the whole condition to appear if the above tick box has a tick
My question is where do I keep all this information (i-iv). Should this information be kept in a separate table or with all the other information for the Form.
I hope you understand what I am trying to do.
Thanking you in anticipation!!!

QUESTION 2:I need a list of items on my Form that people are required to enter a number (1-10) into, some may be filled in but some may not. I need the list to be on the Form but I want ONLY those that have a number beside them to be printed on the Report (sample below).

 fjdjf df djfdjfjd fdfdjfjdfdjjfjdjf df djfdjfjd fdfdjfjdfdjjfjdjf df djfdjfjd fdfdjfjdfdjjfjdjf df
 fjdjf df djfdjfjd fdfdjfjdfdjjfjdjf df djfdjfjd fdfdjfjdfdjjfjdjf df djfdjfjd fdfdjfjdfdjjfjdjf
 fjdjf df djfdjfjd fdfdjfjdfdjjfjdjf df djfdjfjd fdfdjfjdfdjjfjdjf df djfdjfjd

I will need a box on the left side of the text for people to put a number in. I want the number and the text to appear in the Report. Not sure how I would set this up? Do they all need to be in one table or separate tables?
I hope this question is a simple one for someone to help me out, as I have been working on this Form for a while and have spent a lot of time on it and I am getting nowhere. Maybe you can direct my in the right direction.
I hope you understand what I am trying to do. I hope you don't mind me asking two questions.
Thanking you in anticipation!!! 