4 Replies Latest reply on Jan 28, 2016 12:33 PM by Jo_In_Oz

    Services table with multiple categories

    Jo_In_Oz

      If a database had a services table with many different categories of services, and each category had variations, how would this be set up in a table so the user can choose services to enter data on.

      And then if customers used the same services over time, how would the relationship be shown?

      Most importantly, where would the data be entered? Perhaps in the services table with the customer foreign key in place? Would a join table with both product and customer foreign keys produce the records produced in the products table? If so, how to access that information? Perhaps by putting in fields from the parents?

      I am hoping I am on the right track. Which table to use to input data is confusing me currently.