HI

I am working on a Accounts and Inventory Project for a Workgroup. Now, What I did is that I do not define any relation between the tables. I am managing it through code. For exmaple , In the Invoic Form, the user opens the form, it automatically to to the first record of mater, then I filter the detail table and display the reords in Grid having the same invoice number as master.

Similarly I handled all the cases of edit, delete, add, navigation, etc.

I want to know what are the disadvantages of WORKING WITH THE ABOVE APPROACH ? and Wha are the Advantages of defining tables relation in database ????

Thanks a million in Advance.