Database accounts of the bank customers

[Guest]

dear, damian:

Thank you for the tables, I need more harm detail on the composition of each
table and how to link them to get in the end imagine almost complete project

 

[Guest]

Hi again Mahmoud...

Something like this:

tblCustomer
CustomerID autonumber
CustomerName text
etc

tblAccount
AccountID autonumber
AccountCustomerID number (links to CustomerID in tblCustomer)
AccountNumber text
etc

tblTransaction
TransactionID autonumber
TransactionAccountID number (links to AccountID in tblAccount)
TransactionDate datetime
TransactionTypeID number (links to TransactionTypeID in tlkTransactionType)
TransactionAmount currency
etc

tlkTransactionType
TransactionTypeID autonumber
TransactionType text

Hope this points you in the right direction.

Damian.

 

[Guest]

Hiii damian:
I want to thank you for helping me great and please allow me to introduce
you as a result Satosal when i finished the project

thank you again

 

[Guest]

No worries. Glad I could help.

Damian.

Hiii damian:
I want to thank you for helping me great and please allow me to introduce
you as a result Satosal when i finished the project

thank you again