C
croy
Access 2002
tbl_Main Contains a date field. There are 100s of records
in this table
tbl_Sub contains a one-to-many link field for tbl_Main, and
a field for colors. There are 3 records in this table.
I wish to build a query that will show a row for each
tbl_Main record, and also a row for each of the colors that
are not linked to that record, showing the nulls, and puting
the colors in a certain sort order, whether a tbl_Main
record has a related record in tbl_Sub or not. Sort of a
place-holding record-set.
Like this:
tbl_MainId.cDate tbl_Sub.Color
1/1/2001 Blue
red (not really there, but
I want the third color
to show)
9/17/2004 green
Blue (not really there, but
I want the third color
to show)
Red (not really there, but
I want the third color
to show)
12/1/2000 Green
.... and so on.
For the life of me, I can't seem to get this to work.
Any ideas appreciated.
tbl_Main Contains a date field. There are 100s of records
in this table
tbl_Sub contains a one-to-many link field for tbl_Main, and
a field for colors. There are 3 records in this table.
I wish to build a query that will show a row for each
tbl_Main record, and also a row for each of the colors that
are not linked to that record, showing the nulls, and puting
the colors in a certain sort order, whether a tbl_Main
record has a related record in tbl_Sub or not. Sort of a
place-holding record-set.
Like this:
tbl_MainId.cDate tbl_Sub.Color
1/1/2001 Blue
red (not really there, but
I want the third color
to show)
9/17/2004 green
Blue (not really there, but
I want the third color
to show)
Red (not really there, but
I want the third color
to show)
12/1/2000 Green
.... and so on.
For the life of me, I can't seem to get this to work.
Any ideas appreciated.