j4jason83 Posted February 5, 2009 Share Posted February 5, 2009 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 More sharing options...
bcooney Posted February 6, 2009 Share Posted February 6, 2009 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 More sharing options...
j4jason83 Posted February 6, 2009 Author Share Posted February 6, 2009 I thought I had that set up with this relationship. Maybe I don't. Can you advise me on this. Link to comment Share on other sites More sharing options...
bcooney Posted February 6, 2009 Share Posted February 6, 2009 How about something like this? Computers.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now