Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have 2 columns called 'itemnum', from different tables, that contain common values. When I made this column name primary key, and created a tablebox, I discovered that the values do not match but instead they just appear individually in the table, creating duplicate values in the itemnum column. How do I match the same values? Because I also want to display other data relating to the itemnum and there are null columns all over as the itemnum values repeat, displaying only data for the the related columns that appear in their respective table/data source. Thanks.
can you attach the app please. It shouldn't display duplicate values.. Can you look at the table viewer to see if those 2 tables are joined by "itemnum"?