I have tried several things and now I'm completely lost. If someone cares to give me a soultion or thought process to work on then here is the thanks WAY ahead of time. THANKS!!! I just hope I can make this somewhat clear and not so confusing.
Table 1, "master" containes the fields, part1, part2 and part3, as well as others. Table 2, "partinfo" contains part_num and others. Now for the hard part.
Form "info" contains a tab object with several tabs active, 3 of which I want to display information from "partinfo". based on part1, part2 and part3.
Example: When a form object tabpart1 is selected I want to display all the information from the table "info" that relates, description, in stock, supplier, etc. part1=part_num.
I want to do the same for Tabp2 and Tabp3.
I am now confused what my links or relations should be. I need to be able to edit the informaiton here, so a dlookup is not sutible here, I think. I have tried sub-forms on the tabs, but with no success. Any ideas? Thanks again.
Kenneth Houston
MIS
Sherlock, Smith & Adams Inc.
Table 1, "master" containes the fields, part1, part2 and part3, as well as others. Table 2, "partinfo" contains part_num and others. Now for the hard part.
Form "info" contains a tab object with several tabs active, 3 of which I want to display information from "partinfo". based on part1, part2 and part3.
Example: When a form object tabpart1 is selected I want to display all the information from the table "info" that relates, description, in stock, supplier, etc. part1=part_num.
I want to do the same for Tabp2 and Tabp3.
I am now confused what my links or relations should be. I need to be able to edit the informaiton here, so a dlookup is not sutible here, I think. I have tried sub-forms on the tabs, but with no success. Any ideas? Thanks again.
Kenneth Houston
MIS
Sherlock, Smith & Adams Inc.
