Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    85

    Talking Unanswered: Help please.. Moving data....

    I have a main form. What i want to do. is have a selcetor (still unsure what type) but what i want it to do is have an option that the current details on the main form go to the selected table. eg:

    main form

    name
    address
    suburb

    SELECTOR TableA TableB TableC

    when i enter name address and the suburb i then have a decision to tell it which table to put the information.. WOW! does that sound as confusing to me typing as it is to you reading it?


    Idea on how this can be done is grapely much appreciated..
    ta

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    ok 2 ways i cam think of

    1) have an intermediate table listing like

    name
    address
    suburb
    TableName

    Then run 3 Insert Queries one for each table dependant on the TableName Field

    or 2 build your SQL Statement in code using a select case or variables

Posting Permissions

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