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  

  • Who Viewed the Topic

    1 member has viewed this topic:

Important Information

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