I am trying to run a query from code like that:
I have a table with bookmarks, each bookmark pointing to a row in this table. The row contains : field description,field source_ID , source table_ID ,and others.
According to the number of bookmarks, each filed source_ID will be a field in the query from his source table.
For each field source_id i get the records in a listbox, and select from these listboxes items that will be the criteria for my query, and put the selected items in a list box, one for each field source_id.
I am interested to build a query with this data , and I have same problems with the relationships between the tables, because here are involved some tables and there are relations between them. I am trying to use the relations collection but I don't understand why MyDataBase.Relations.Item(item_no) doesn't work , it return a null, and calling MyDataBase.Relation.Count return the number of relationships in my data base. Running with the debuger I see the relations.
What's the problem and how can I build such kind of query.
Thanks, Richard