dcsimg
Results 1 to 4 of 4

Thread: Relations between two tabels....

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2019
    Posts
    2

    Post Relations between two tabels....

    Hi...
    I have been away from programming for 15 years now... Now I would like to do some programming again. Im now using visual studio 2017. There is happen a lot since 2003... And im confident in using vs2017. But I cant solve this problem:

    I have two tables tblcustomer and tblcustomer_contact. On my form I have tblcustomer as Testbox and tblcustomer_contact as datagirdview. I have field tblcustomer.customerId and tblcustomer_contact.Idcustomer as relationship

    When I run, the datagridview show me all fields.....
    I need the syntax for select *.* from xxxx where yyyy=zzz
    my db is access 2002

    I hope there is one there can help me... Thanks

  2. #2
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    3,878

    Re: Relations between two tabels....

    You should always post the relevant code. What kind of database? We have no idea what you have written and there is more than one way to achieve what you want depending on how your interacting with the database.

    My guess would be that you need to setup a relation between the two tables. Member jmc has an excellent example of that in the code bank. http://www.vbforums.com/showthread.p...ms)&highlight=

    EDIT - I see your database is Access 2002. I believe that uses the Jet provider, creates a MDB file. Which is fine, it's more than capable for simple desktop programs.
    Last edited by wes4dbt; Jan 5th, 2019 at 04:37 PM.

  3. #3

    Thread Starter
    New Member
    Join Date
    Jan 2019
    Posts
    2

    Re: Relations between two tabels....

    Okay Thanks... Sorrry

  4. #4
    PowerPoster TysonLPrice's Avatar
    Join Date
    Sep 2002
    Location
    Columbus, Ohio
    Posts
    3,187

    Re: Relations between two tabels....

    This is a nice tutorial for SQL basics. It has sample tables to work with.

    https://www.w3schools.com/sql/sql_intro.asp
    Please remember next time...elections matter!

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width