[Hunyo Silaw]

[img]https://fbcdn-sphotos-e-a.akamaihd.net/hphotos-ak-prn1/734084_2599721049175_1136199448_n.jpg[/img]

above is my database design.


before continuing, I would like to say hello to all..

ok.. here in my db design I have a otherinfo table. this table contains details related to a student if a student belong to a certain department. this is because not all department joins with sport events.

is it possible to manage this two tables into one?

example:

table:
[img]https://fbcdn-sphotos-f-a.akamaihd.net/hphotos-ak-snc7/301887_2599754770018_364346054_n.jpg[/img]

in add/edit:
[img]https://fbcdn-sphotos-h-a.akamaihd.net/hphotos-ak-ash3/574742_2599754850020_1620476336_n.jpg[/img]

And then after saving... the details will be inserted in the two tables or in just one table if, like I said, the department chosen is not active with sports.

Thank you very much guys.. need your help... I just want to know if there is a way to do this the easy way with the current functionalities available.. but I'm also open with a work around.

God bless and more power to you guys!!