Recent content by ehazel2001

Ok, so I have this database that I've created to process catering orders for a restaurant. These are my tables: Customer ID (PK) Customer Name Address Telephone Equipment ID Equipment Name Price Menu Item ID Menu Item Name Specifications Type of Food Staff ID Staff name Job Telephone Email...

So I get that I have a many to many relationship between my New Job & Equipment tables....I created a junction table called Equipment Details...It contains the following fields (ID, Job ID, Equipment ID, Quantity, Price) How do I set up the M2M relationships between Job ID & Job ID, Equipment ID...

Ok, so I have this gigantic database that I have created to deal with catering jobs for a restaurant. It has multiple functions, it tracks menu items, catering equipment, personnel & clientele. All these are represented as such with tables: Tables Customer Equipment Menu Item New Job Staff The...