var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: field update
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???
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.
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
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
Thanks for the subselect statement
Your help is greatly appreciated.