0

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

2
Contributors
1
Reply
3
Views
7 Years
Discussion Span
Last Post by ppetree
0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.