I am working on a database to in time replace standard excel forms that depict the terminations/time-slots of communications equipment (typically capable of 24 connections on each terminal)... The query does return only "connected " positions ie 1,5,9,17 but the subform needs to show all 24 positions whether a connection record was returned or not.
I don't want to add thousands of "blank" records to the connection table, the table will be large enough without adding "non-connections". I considered looping through 1-24 and selectively running the query for a single connection position - if the query returns zero/null individually populating the subform-table but I haven't has much success.

more simply i need it to create a list showing all possible positions 1 through 24... and populate the the list where there are connections from the connections table for that terminal.

1- connected to terminal 5.17
2-
3-
4-
5- connected to terminal 3.1
6-
7-
8-

and so on... can i inject the blanks into the sub form without alot of extra unneeded data entry

Thanks