Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Need place multple fields in one field (2002)

    Hi,

    I have a form that has multiple check boxes on it (there can be as many as 150/form) Each checkbox corresponds to a picture. The person viewing the picture places a check in the box if they want it. Each check box is contained in tblCandid - temp as a separate field. The goal is append the checkboxes that user selects to tblCandidChoices and to have them go to one field [choicenumber]. I tried doing and append query and put in all of the fields and had them go to [choicenumber] but got a duplicate Output Destination error. Since this didn't work, how would I go about accomplishing this?

    Thanks,
    Leesha

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need place multple fields in one field (2002)

    You'll have to provide much more information if you want us to help you. If the values of all the check boxes should go into one field, I assume that each should go into a separate record. How is this record to be identified?

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Need place multple fields in one field (2002)

    Hi Hans,

    Yes, each checkbox should go into a different record. Presently the checkboxes are identified as c1, c2, c3, etc. I'm not quite sure what you mean by how is the record to be identified, so with that being said, I'm open to any suggestions you have.

    Thanks,
    Leesha

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need place multple fields in one field (2002)

    You can't just dump 150 True/False values in a table, you wouldn't know what belongs to what. So I repeat, you'll have to provide much more information about what you're trying to accomplish, the table structure, etc.

  5. #5
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Need place multple fields in one field (2002)

    I think I'd better go back to the drawing board.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need place multple fields in one field (2002)

    I'd try a different design: instead of 150 check boxes, use a multi-select list box or a subform.

  7. #7
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Need place multple fields in one field (2002)

    Thanks Hans! To make matters worse (design wise), the table is an database that will be on the internet and the user will be using Frontpage to enter the data. I've tried using the datapages but find them soooooooooooooooo frustrating because they don't work like an access form (from what I can tell) and then I get errors when trying to publish it. So, I resorted to using a frontpage form to gather the data. The prolbem with that is the it doesn't allow (from what I can tell) subforms etc. If I were simply setting this up in Access I'd be having a much less difficult time as m approach would be different. I'm so frustrated! I've got every book you can think of on my bed trying to figure this #@!#!@ out.

    Thanks,
    Leesha

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need place multple fields in one field (2002)

    OK, so subforms are out. I don't know if you can use a multi-select list box in FrontPage - perhaps someone else can tell you that.

    If you do need the 150 or so check boxes, you'll have to use other fields in the table beside a Yes/No field to specify what each Yes/No value belongs to.

  9. #9
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Need place multple fields in one field (2002)

    I don't know anything about Frontpage, but the HTML equivalent of a listbox is a SELECT tag. By default SELECT elements are not multiselect, but if you include the attribute 'multiple', then they do allow multiselection. Mutliselection requires CTRL or SHIFT clicking.
    <select name="test" size="10" multiple>
    <option value="1">abc</option>
    <option value="2">def</option>
    <option value="3">ghi</option>
    <option value="4">jkl</option>
    <option value="5">mno</option>
    </select>

    However a SELECT item with 150 items would not be very practical. Perhaps you could categorise them, and have several separate shorter lists.
    Attached Images Attached Images
    Regards
    John



  10. #10
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Need place multple fields in one field (2002)

    Thanks for the info! I find my mind thinking in Access and then trying to find the equiv. in html and its a struggle. I'll see what I can come up with in this direction. At the present time I have the information from the checkboxes coming to me in a tab deliniated email which I then pull into Access and work with from there. It's a workaround at best, but till I can figure all this stuff out its a start.

    Thanks again,
    Leesha

  11. #11
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Need place multple fields in one field (2002)

    Hi again Leesha

    Here is my take on this. I have the responsibility of looking after a Customer Relationship Management System with approximately 8 external database integrations in one shape or form. Direct integration from HTML to the database is nigh on impossible as there is a mixture of code flavours. Your comment on Access and HTML spurred me on to make this comment.

    Sometimes with all the best will in the world we can over complicate our electronic systems hence my signature below from Ockham's Razor which loosely translates as "entities should not be multiplied unnecessarily" or to put in a modern phrase "Keep It Simple Stupid" <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    At some stage there will be a requirement for human intervention in some shape or form, CRM systems rely on Business Process to drive its electronic routing and your application sounds like this could be an opportunity to implement this.

    I suggest that you create a HTML form, with multi-select options as pointed out above which outputs to a TXT/CSV pipe or comma delimited file which could be uploaded to your database on a 24 hour cycle. From my experience a lot of websites are built with smoke and mirrors. The user presses a button thinking some wonderful etherial action is taking place when in fact it is just sending an email to a back office hamster who inputs it manually. You can have a message on the website that states, "This site is updated on a 24 hour basis", you will be surprised how forgiving users are.

    Just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15> worth
    Jerry

  12. #12
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Need place multple fields in one field (2002)

    Hi Jerry!

    I'm howling laughing because that is exactly what I've figured out. All this time when I've gone to a site I've "thought" there was someone just waiting on the other side to process my request when in fact its exactly how you described! The spoiled little girl in me wants to be able to setup a webpage that actually dumps to a database and is manipulated in real time from some remote computer, however I'm realizing in all the reading I'm doing that it is not only not an easy undertaking, but its not too practical to do.

    With this said, and taking your post into consideration, how do webpages that have items such as those with shopping carts that give immediate feedback work? Is that real time response or just the way the site is coded?

    Thanks!
    Leesha

  13. #13
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Need place multple fields in one field (2002)

    I will be back in a bit, i will log into College and see if there are any e-commerce hands on exercises. No promises but we are going down the road of Database/HTML so we will be jumping between two disciplines (again) <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  14. #14
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Need place multple fields in one field (2002)

    Cool! Can't wait to hear back from you when you get a minute. I'd hate to keep wasting my time trying to create something I "see" in my head but doesn't in reality exist.

    Leesha

  15. #15
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Need place multple fields in one field (2002)

    Hi Leesha

    Sorry for the delay but Mrs J was bellowing "Get off <img src=/w3timages/censored.gif alt=censored border=0> Woody's and take me to the garden centre" <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    Right, back to Ockham's Razor...why re-invent the wheel when we have open source and freeware out there.

    Try these, they look pretty good options IMHO

    Quick Cart

    Comersus Cart

    There appears to be a CSS requirement to get it to look and feel like your site and a bit of hard work configuring the items on sale, but a lot easier than building it from scratch.

    If you think these are a goer then we can start talking options then...good luck

    BTW not much in the college stuff, sorry
    Jerry

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •