Really nedd help with this DB

[leeshadmi]

I use VB.Net 2008 with SQL server express edition 2005 in this project.
I attached the database files and a picture of the database diagram and I hope some one can understand what I need to do and help me out with this since I just can’t figure it out by self.
This database needs to store receipts data like all the vendors details and the branches of each vendor and the receipt data like total, tax and more.
I define all the fields that I need to save in few tables and I create a master table called RecID to be the one that will help me to navigate between the receipts but I think it’s not good and I thing that I might did bad job defining this DB.
After I will complete to build this DB and to add the right relationships between the tables (hopefully with your help) I want to create binding to the controls on my form (one form few controls each for the relevant field in the DB)

Can any one help me with this?
I try to read and see vids on the web but I just don’t figure it out.
Many thanks for the angle that can help me.
:blush:

[Alsvha]

Do you have any specific questions? Or areas of problems?
Do you need help with seeing what relations there should be? Or ....

It is a bit difficult to help you out if you only ask "Can any one help me with this?" after an introduction to the project.

[leeshadmi]

First i need to know if this structure is ok (For example is the RecID table needed)?
After that if you can please help to set the relations beween the tables.
and at last i will need help to understnad how to bind all this to controls on my form
Thanks....

[Thread1]

Since you have started it from top to bottom, try to look for an ORM tool (ex, nHibernate) to generate the corresponding tables/schema for you objects.

Hope that helps.