Form Coding from SQL Linked Tables

[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

 

[Albert D. Kallal]

Why not build a sub-form based on the 2nd child table

Try using the wizard. If you do this, then you not have to write any
code....

And, a sub-form can look almost like a list box anyway....