Results 1 to 5 of 5

Thread: field update

  1. #1
    Join Date
    Nov 2003
    Posts
    74

    Unanswered: field update

    hi all,

    i have a search form where i want to display the fields in the form from 3 different tables.
    i have attached a db for your reference.

    how can i do that???

    pls advice
    nono
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Use Joins

    Hi

    What is the information that you want to achieve, I mean which fields do u want to display, can u please provide us some information.

    The same can be obtained using joins and nested selects.

    Please also let us know your database, operating system this is mandatory.

    regards

    nitin.

  3. #3
    Join Date
    Nov 2003
    Posts
    74

    fields update

    hi,

    the form that i have attached is the fields that i want to display. but however i do not know how to retireve data from 3 tables as a time.

    pls guide me along to get all the fields on that form.

    as requested :
    db - database 2000
    os - win2000

    pls advice
    nono

  4. #4
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Query.

    Hi Nono,

    Is this the information you need to display.

    SELECT BranchInformation.Branch Code, BranchInformation.Branch Name, Customer_Account_Table.Account No, Customer_Account_Table.Account Type, Customer_Account_Table.Balance, Customer_Account_Table.Quantity, Customer_Table.Name, Customer_Table.NRIC, Customer_Table.Address, Customer_Table.Contact No
    FROM Customer_Table INNER JOIN (BranchInformation INNER JOIN Customer_Account_Table ON BranchInformation.Branch Code = Customer_Account_Table.Branch Code) ON Customer_Table.NRIC = Customer_Account_Table.NRIC

    Please use the wizard facility in db2 which is really helpful.

    You can also use the create query in design view in access.

    Hope that helps

    Nitin

  5. #5
    Join Date
    Nov 2003
    Posts
    74

    field update

    hi all,

    Thanks for the subselect statement
    Your help is greatly appreciated.


    Cheers!
    nono

Posting Permissions

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