October 9, 201015 yr I have a DB with multiple tables that will store similar items, such as, Cars, Trucks, Vans, SUVs, etc. We'll calls this "Categories". I want to have a popup list that allows them to select the Category and then change the layout to suite that type of vehicle. I thought I could create a table called "Categories" and then a table for each type of vehicle. I then created a table occurrence called "Cars" where the Cars table is linked to the Categories by a key field. Since I need to add records to the Cars table, but not to the Categories table. The Categories table has one record for each type of vehicle and I created a value list based on the records in the category table. I then put the Category field at the top of the screen and the fields from the Cars table underneath it. What I want to happen is that when I change the Category, I want to move to another layout for the category selected. However, I keep getting a message that the category is from an unrelated table. Is my approach all wrong?
October 10, 201015 yr You're struggling with a subtype/supertype structure, imho. This thread may be helpful: http://fmforums.com/forum/showpost.php?post/288333/
Create an account or sign in to comment