Tables relation 1 to many

[ADRICHECKIN]

Hi team,

Want to make a relation between 1 to many from Table_B to Table_A.

In TABLE_B there are duplicated values.

How can I detect this duplicated values from Table_B? ( real table has many rows..)

Any other solution?

TABLE A		TABLE B
CLIENT	ORDER	REF	REVEN		CLIENT	ORDER
A	P100	XX	100		A	P100
A	P100	ZZ	110		A	P101
A	P101	XX	120		B	A102
A	P101	YY	130		B	A102
B	A102	BB	140
B	A102	CC	150

thanks,

[Icey]

Hi @ADRICHECKIN ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards,

Icey

[amitchandak · Accepted solution]

@ADRICHECKIN , Delete duplicate as suggest by @MFelix .

Also you need a concatenated column in both tables to join

Key = [Client] & "-" & [Order]

[MFelix]

Hi @ADRICHECKIN,

On the query editor select all row from table b and remove duplicates that should clean the information.