i have a table contains company and each company have many branches
and each branch has ROOM like stock , lobby , kitchen..
and i have a table productslist contains products
how i can implement movement of products form room to room
maybe the movement occurs in the same branch location
or between the two room located in different branch ???
please can any one help me on implementation
create table company :( companyid , companyname )
create table branch ( branchid , branchname , companyid )
create table room ( roomid , roomname , branchid )
create table products ( productid , productname , serialnumber ,condition )
// condition is : NEW , OLD
first step the products is should be stored in the main company1 bracnh1 room1
than i want to move it to another company name : company2 branch1 room2
or i cam move it to company1 branch2 room1
i want to implement this transaction ? by how ? and i want to save the transaction log...