Jump to content
Sign in to follow this  

Conditional Value List

Recommended Posts

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.


Share this post

Link to post
Share on other sites

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.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.