N
News
Hi,
I have a few linked tables in my Access database (Incidentally, the linked
tables are linked via an odbc connection from out SMS server)
Everything is fine, the data is coming in as expected, however, what I am
trying to do is for each PC list the software installed, please see the
example below:
eg:
Table PC
id name
1 pc1
2 pc2
3 pc3
Table Software
id prodname
1 cutepdf
1 office
1 printnow
1 winzip
2 nero
2 office
2 printnow
2 winzip
3 office
3 printnow
3 trucrypt
3 winzip
What I would like is for a form to show for each id the record (only once)
showing a listbox with all the installed software.
Any help would be greatly appreciated
Many Thanks
Andy
I have a few linked tables in my Access database (Incidentally, the linked
tables are linked via an odbc connection from out SMS server)
Everything is fine, the data is coming in as expected, however, what I am
trying to do is for each PC list the software installed, please see the
example below:
eg:
Table PC
id name
1 pc1
2 pc2
3 pc3
Table Software
id prodname
1 cutepdf
1 office
1 printnow
1 winzip
2 nero
2 office
2 printnow
2 winzip
3 office
3 printnow
3 trucrypt
3 winzip
What I would like is for a form to show for each id the record (only once)
showing a listbox with all the installed software.
Any help would be greatly appreciated
Many Thanks
Andy