Hey, Team!
I currently have an information database for about 115 companies. There are several tables such as "Company Information", "Amortization", "Plant Location", "Manufacturing Capabilities", etc.
I want to be able to open one form, such as "Company Overview" and have it link to another form, "Company Capabilities", for the same company.
E.g. When viewing the "Company Overview" form for Target, I would like a link to Target's cabailities form.
Also, the "Company Overview" form currently has multiple records for each company; thus, my form has 794 entries instead of 115. Is there a way to "Group By" similar to reports?
Any help for these two questions would be greatly appreciated. Thank yoU!
I currently have an information database for about 115 companies. There are several tables such as "Company Information", "Amortization", "Plant Location", "Manufacturing Capabilities", etc.
I want to be able to open one form, such as "Company Overview" and have it link to another form, "Company Capabilities", for the same company.
E.g. When viewing the "Company Overview" form for Target, I would like a link to Target's cabailities form.
Also, the "Company Overview" form currently has multiple records for each company; thus, my form has 794 entries instead of 115. Is there a way to "Group By" similar to reports?
Any help for these two questions would be greatly appreciated. Thank yoU!