Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2002
    Location
    Sweden
    Posts
    14

    Unanswered: Connection-problems

    I have a table containing an ID-field and three text-fields, a form based on this table and a query containing an ID-field and a text-field. Is it posible to (in a textbox in the form) view the value of the text-field from the query for those posts where the ID-field from the query matches the ID-field from the table (the query may sometimes just contain about 10 posts). For those posts with an ID not in the query I want the text-box to be empty.

    Hmm, hope you understand though my english sucks=)
    Thanks

    /Sebastian
    Sebastian

  2. #2
    Join Date
    Jan 2003
    Location
    Dordrecht, The Netherlands
    Posts
    95

    Re: Connection-problems

    Design a query for the form that joins the table with the query on their ID's. The join has to be an outer join showing all the records from the table, even if the corresponding record in the query is absent. Then bind the text-field to the query text-field.

    Hope this helps.

    Ad Dieleman.

  3. #3
    Join Date
    Nov 2002
    Location
    Sweden
    Posts
    14

    Re: Connection-problems

    Well, yes it works if I do it that way. But I also wanna be able to store some calculated data in the table. Is there anyway to do it even if I base the table on the query?

    /Sebastian
    Sebastian

  4. #4
    Join Date
    Jan 2003
    Location
    Dordrecht, The Netherlands
    Posts
    95

    Re: Connection-problems

    The query that the form uses is in general updateable, meaning that you can do inserts, updates and deletes in the fields of the query. Make sure that all tables in the query have primary keys and define these primary keys as fields in the query, then most probably the query is updateable.

    Ad Dieleman.

Posting Permissions

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