February 25th, 2000, 01:12 PM
Hi,
here is my question. I have 2 fields in my recordset. A rs!relationship(mother, father.....) and rs!relation_id. I need to populate an array with both of these fields of the rs. I also have a grid where these fields show up in 2 columns. When the user tries to change a name I have to call the array and see if that relationship in that particular cell and row already has an id. (e.g. mother = 1, father = 2....). If the relationship matches with an id than I have to take this id and put it in a variable(relationId) for further use. If the relationship is not in the array I need to add it to the array and give it a new id and take that new id and put it in the variable(relationId).
I have absolutely no glue about arrays. So, please help!!!!!!! I am working with an adodb.rs.
Thanks for any help that I can get.
Christa
here is my question. I have 2 fields in my recordset. A rs!relationship(mother, father.....) and rs!relation_id. I need to populate an array with both of these fields of the rs. I also have a grid where these fields show up in 2 columns. When the user tries to change a name I have to call the array and see if that relationship in that particular cell and row already has an id. (e.g. mother = 1, father = 2....). If the relationship matches with an id than I have to take this id and put it in a variable(relationId) for further use. If the relationship is not in the array I need to add it to the array and give it a new id and take that new id and put it in the variable(relationId).
I have absolutely no glue about arrays. So, please help!!!!!!! I am working with an adodb.rs.
Thanks for any help that I can get.
Christa