Jump to content

Conditional Value List


j4jason83

This topic is 5529 days old. Please don't post here. Open a new topic instead.

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.

Jason

Link to comment
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.

Link to comment
Share on other sites

This topic is 5529 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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