Everyone,
I'm really stuck on this one. i feel like I should be able to figure it our, but I can't. Here's the deal:
1. I have table1.y - "y" is a lookup list with three possible values in it. The user sets "y" through a form right at the start of the program.
2. In another table I have a lot of records each with a setting that corresponds to the setting in table1.y Let's call this other table/field table2.y2 {I know this isn't the best design, but it is what I'm working with).
3. I have another form that I want to show all the records from table2 that are equal to the setting the user put in table1.y at the start.
4. One more wrinkle - let's say the three possible values for table.y are "apples", "oranges", or "both", and when the value for table1.y is "both" I want it to show all the records from table2.
Does that make any sense at all? Like I said I feel like I should be able to figure this out, but I'm completely stuck. Any help is greatly appreciated!!!
I'm really stuck on this one. i feel like I should be able to figure it our, but I can't. Here's the deal:
1. I have table1.y - "y" is a lookup list with three possible values in it. The user sets "y" through a form right at the start of the program.
2. In another table I have a lot of records each with a setting that corresponds to the setting in table1.y Let's call this other table/field table2.y2 {I know this isn't the best design, but it is what I'm working with).
3. I have another form that I want to show all the records from table2 that are equal to the setting the user put in table1.y at the start.
4. One more wrinkle - let's say the three possible values for table.y are "apples", "oranges", or "both", and when the value for table1.y is "both" I want it to show all the records from table2.
Does that make any sense at all? Like I said I feel like I should be able to figure this out, but I'm completely stuck. Any help is greatly appreciated!!!