I want to create a database for manage equipment in restaurant such as chair,table,fork,spoon,glass.....
i have table like this :
tbldate ( dateid )
tblbreak ( dateid, equipmentid, qty, unitprice, reason )
tblequipment ( equipmentid, name, qty, unitprice )
tblbuydetail ( equipmentid, buyid, qty, unitprice )
tblbuy ( buyid, date, invoiceno, supplier )
This relationship is good or not. can everybody help me? and about form design?