Tables:
Request - 1:n with RequestComments
Request - 1:n with Item
Item - 1:n with ItemComments
ItemComments has foreign keys to RequestId and ItemId.
Item has a foreign key to Request
RequestComments has a foreign key to Request
Since I am not using SelfService I could use some help in how to go about this.
I have a form that a user enters in all of this and would like to have it all inserted to the database in one go.
Thanks,
Ren
Sorry posted in the wrong spot. I reposted this in the general forum.