How to do this?

[jjfcpa]

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?

[bruceR]

No way to know. We don't have a copy of your file.

[bcooney]

You're struggling with a subtype/supertype structure, imho. This thread may be helpful:

http://fmforums.com/forum/showpost.php?post/288333/