I am building a small restaurant management system. There are two tables: items and categories. cid field of item is foreign to the table category(cid). How do I link those in databases. And, in the front end in the file cid of table item the name of category should be displayed.
How do I do it? Please help !!
