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

I think you're missing a field in your tables. I think after ID you need CUSTOMER_NUMBER and CUSTOMER_NUMBER should be the same for each account and should be the ID from the customer record.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.