Having problem with DataSet populated from MS Access db. It is generated from Union query and can contain not unique records, e.g. query result:

ID Amount
10 25
11 30
10 25
15 40
…

Dataset simply deletes repeated record, so in the dataset records presented as:
ID Amount
10 25
11 30
15 40
…

Because dataset populated from two quite similar tables, the uniqueness of records cannot be guaranteed (including more fields in the result query cannot it provide as well).

One solution can be: get two datasets from the both tables and add records from the second dataset to the first one, setting datarow ‘ID’ to some unique number. But I am wondering, is there any properties in a dataset object which will allow to keep all records, or may be there is some other simple way to solve this problem?