Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008

    Unanswered: save last 5 status and show only the latest in a form

    i have table with fields name,phone and status1,status2... status5
    i have a form to add records which uses status1.
    now i want to build a form to update status... it should how many fields for status i have used.. and allow me to fill the new one...

    how can i do so.
    plz help..

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    if you have columns with the same name and a numeric suffix then that often indicates a dodgy physical design of the db

    however you can get round that by accepting a value in an unbound control and then 'posting' that value to the appropriate status control

    how do you propose to handle edits of the status controls
    how do you propose to handle deletions of status (and presumabnly shuffling up values for higher suffixes
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2007
    Provided Answers: 12
    What healdem is saying is

    redesign that there table!
    Home | Blog

Posting Permissions

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