Electronic Bank Statement

[Former Member]

hi friends,

i want to retrive the data for Electronic Bank Statement

so i found the tables

header tabel------- febko

items table -

---

febep

management records---- febvw

i want to join these tables to retrive the data

how can i join these tables ?

and what is the relation among the tables?

thanks & regards

srinivas

[Former Member]

hi sri,

hope it helps.

these tables have fields in common.

in febrw: anwnd, absnd, azidt are primary key,

in febep : kukey and esnum are pkey,

in febko: anwnd, absnd, azidt,emky are pkey but it also has a field Kukey.......

so with these common fields between them you just join them with for all entries

reward if useful.

regards,

srishti

[Former Member]

hi sri,

hope it helps.

these tables have fields in common.

in febrw: anwnd, absnd, azidt are primary key,

in febep : kukey and esnum are pkey,

in febko: anwnd, absnd, azidt,emky are pkey but it also has a field Kukey.......

so with these common fields between them you just join them with for all entries

reward if useful.

regards,

srishti