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

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.

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

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

hi all,

Thanks for the subselect statement
Your help is greatly appreciated.


Cheers!
nono