Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

one to many solution needed

Status
Not open for further replies.

sandygo

Technical User
Sep 17, 2002
4
US
I have three tables. One with old system report names and info, one with data elements, and one with new system report names and info. I built a form to get info from both system report names and info. Each report can contain several data elements. I need to identify all the data elements for each report. There are approx 200 data elements to choose from. Ultimately, I need one list of all the data elements required, but I only need them listed once. I don't know what the best way to go about tracking these separately and then being able to get one final list is. How can I choose multiple data elements in a form each report?
 
Sounds like a combo box with the SELECT DISTINCTROW is what you need.

Rollie E
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top