Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    31

    Unanswered: Linked combo box problem

    I've got a form that's used to add notes related to another entity -- a parent---<child relationship.

    At the moment, the child just stores a unique project id number (that is unique across all clients etc.). I've added code to allow the user to drill down through clients so that only projects for a given client are shown. However, when you then move to a new record, since the form is bound to just the child entity, the client box is not filled.

    I've tried adding code to search for the client of the current project and set the text to be the correct one, but it seems to then clear the project list box.

    Has anyone tried doing this, if so, any suggestions?

    Thanks

  2. #2
    Join Date
    Mar 2002
    Posts
    31
    I should also say that I tried creating a view that contained all the necessary fields so that the combo boxes could be databound (and retain the code I'd already got for when adding records).

    However, I can't then create a new record -- saying I can't edit the ID field for the client within the view.

Posting Permissions

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