1 for Tickets.. (stores, the request a user submits) 1 for client, (stores clients) and 1 table for Managers(stores employees)
how do i make a column for ticket tracking.. that will either tie a ticket to a client OR a Manager?
The client and manager tables can be the same table, called Contact. Add a field named Contact_Type and in there specify the class of contact, i.e. Customer / Manager. Merge the tables and populate the appropriate fields only accoring to contact class. The TICKETTRACKING table then becomes: TICKET_ID, CONTACT_ID only - both FK's and combined the PK for the table.