haw can i make tree in access
please with sample

Please elaborate. What is the purpose of the tree?

the purpose of the tree make balance steet and net profet . make assest and debets and Fixed_Assets and Liabilities and Revenues and Expenses and ,,,,,,,

Why do you need a tree structure? What's wrong with the list structure provided?

dear midimagic
it had plased me to show your replay the problem with tree i solve it . the problem naw while i do invice (pay or sell) haw can its value go to the buyer and acount of buyer (debit and credit) in thr tree
thanks

If I understand what you are saying, I think you need to link the tables together with a key field (account number?).

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.