I am converting an Access Database to Filemaker. In the main table for jobs the status, location and such was stored as just a number. Another table stored all the menu items and choices. The menu table has a category field and a status field and description field. The status field can hold the same number, say 5 in all the different catagories. To see the correct description I have been forming two part relationship for each combination. Right now I have 12 occurrences of the same menu table in my relationship graph. I am also having to add category calculation fields to my main table for each one. In the access database this was done thru joins whenever needed so that category is always hardcoded in.
Is there an easier way to do this than making so many occurrences of the same table?