Conditional Value List

[j4jason83]

I really hope I haven't missed something in my searches, but I have been unable to make this work.

I have 2 tables, components and computers. In my components table, I input all the info about each part of the computer.

Now I want to create a list for each part of the computer, (motherboard, processor, RAM, etc) that pulls data from the components table, but filters the results to the corresponding field.

I am not sure what I need to do to get this function to work.

Thanks in advance.

Jason

[bcooney]

You're missing a table. Since a computer can have many components, and a component can be used on many computers, then you need to store the intersection. This is called a join table, and it resolves the many-to-many relationship.

Search the forum for "join table."

You'd put a portal on the Computer form to the join table, and populate the _kF_ComponentID.

[j4jason83]

I thought I had that set up with this relationship.

Maybe I don't. Can you advise me on this.

[bcooney]

How about something like this?

Computers.fp7.zip