lycanhunter
Posts: 11
|
Posted: 04/15/2010, 12:25 PM |
|
OK Sure we have seen the reuest before in one fashion or another. I however have not found an answer that functionally works. So here is my own rendition of the question.
Making a directory like table which show Residents, address, phone, etc... in one row
and the next (dynamic amount of rows) show the kids of said resident.
Then next row of resident and their kids
and so on.
data is in two tables with a reference ID between the tables to link them.
///////////////////////////////////
resident smith - 1234 north main - 555-1212
little johnny smith - bday 1/1/2000
little suzie smith - bady 1/1/1990
Resident Jones - 4567 s main - 555-1234
no kids....
Resident abyss - etc....
ad nauseum
Not every resident has kids though.
Thanks in advanced for any help. When I have tried even using SQL DISTINCT I get a line with the resident and each kid each time. in each row.
_________________
That is not dead which can eternal Lie.. |
|
|
Waspman
Posts: 948
|
Posted: 04/20/2010, 3:42 AM |
|
Have you tried a report?
_________________
http://www.waspmedia.co.uk |
|
|
lycanhunter
Posts: 11
|
Posted: 04/20/2010, 5:13 AM |
|
I purchased the personal edition only. Guess I either have to pay WAY too much or custom code it myself. Thanks for the thought though.
_________________
That is not dead which can eternal Lie.. |
|
|
Waspman
Posts: 948
|
Posted: 04/20/2010, 8:42 AM |
|
It's worth if for the report builder, you can use it is so many ways
_________________
http://www.waspmedia.co.uk |
|
|
|