Hi,
I have 4 account type tables.
savings_investment(ID,account_type,full_name,balance,interest,customer_id)
shakthi(ID,account_type,full_name,balance,interest,customer_id)
surathal(ID,account_type,full_name,balance,interest,customer_id)
abhimani_plus(ID,account_type,full_name,balance,interest,customer_id)
The ID is different from one table to another. That is why i created 4 tables rather than one table.
I want to write the coding to check account balances. That is if user types the ID and clicks on search button the relevant details regarding that account should be shown in a table. That is account_type,full_name, balance, interest and customer_id.
Can anyone give me the relevant coding...
Thanks,
Heshan