Skip to main content
Answer

How to stop duplicates in a generic inquiry via join types

  • September 17, 2025
  • 5 replies
  • 122 views

Forum|alt.badge.img

Hello!

I”m having issues implementing relations to support my results in a GI.

I can list out all my sales orders, which type of order they are, warehouses and customers list no problem. However, once i implement an “address” feature, it breaks my GI and duplicates everything.

 

I’ve read and reread the join type explanations and it seems that i want an “inner” join type. But i’m thinking i may not still understand this. 

anyone have an idea on how i can stop these duplications? 

Best answer by kdolgner

 

After an embarrassing amount of time and research i figured out how to get rid of my doubles..

now to go break it some more by adding other things.

 

5 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • September 17, 2025

@kdolgner without seeing your joins it would normally be a left join but an inner can work what field are you using to join the two tables as if you dont use the correct join you will get multiple results depending on the number of records that meet the join conditions in your table.

Share a screenshot of the Relation tab of the GI


Forum|alt.badge.img
  • Author
  • Freshman II
  • September 17, 2025

@kdolgner without seeing your joins it would normally be a left join but an inner can work what field are you using to join the two tables as if you dont use the correct join you will get multiple results depending on the number of records that meet the join conditions in your table.

Share a screenshot of the Relation tab of the GI

Sorry about that ! i thought one of those screen shots was that screen, as it’s my problem screen after all.. 

 

 

my next step is to add a column to reference what warehouse they’re coming from; but i’ve figured out how to do that via other inquiries, i think. 


dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • September 17, 2025

@kdolgner you only gave me top half of relations tab I need to see the fields you are using 


Forum|alt.badge.img
  • Author
  • Freshman II
  • September 17, 2025

@kdolgner you only gave me top half of relations tab I need to see the fields you are using 

i have nothing down there!

what fields would i want to reference? 

I typed in “SOOrder” and there was quite the list. 


Forum|alt.badge.img
  • Author
  • Freshman II
  • Answer
  • September 18, 2025

 

After an embarrassing amount of time and research i figured out how to get rid of my doubles..

now to go break it some more by adding other things.