Form question

  • Thread starter Thread starter -LeguMan-
  • Start date Start date
L

-LeguMan-

Hi,

I have a form who shows data from a database. One of the field is a code who
forward to other items like that

Name ID_FAMILY
David A
Ben A1
ChristineA2
Micheal A11

Where Micheal is the soon of Ben and Ben the soon of David.

In one listbox, I'd like to view all the soon of a person.

I'm looking for such kind of query but as I am a newbies in access, I don't
know how to write it and worse where to put it in my listbox !

SELECT table1.NAME, table1.ID_FAMILY
FROM Table1
WHERE ID_FAMILY like "CURRENT_ID_FAMILY*";

Any help would be greatly appreciate,
Vincent
 
I have a form who shows data from a database. One of the field is a code
who
forward to other items like that

Name ID_FAMILY
David A
Ben A1
ChristineA2
Micheal A11

Where Micheal is the soon of Ben and Ben the soon of David.

In one listbox, I'd like to view all the soon of a person.

I'm looking for such kind of query but as I am a newbies in access, I don't
know how to write it and worse where to put it in my listbox !

SELECT table1.NAME, table1.ID_FAMILY
FROM Table1
WHERE ID_FAMILY like "CURRENT_ID_FAMILY*";
Click to expand...
-------------
Hi Vincent,

I'm afraid Access SQL doesn't support recursive queries which is what you
need to get your results. You may have to write some VBA code to accomplish
this.

Hope this helps,
 
Back
Top