Tables and Relationship table

[AngelP83]

Hello everyone,
I hope someone can assist me or point me to the right place.

This is what I am trying to accomplish.  A record producer that will ask for Product ID, and Location of that product.

We created a Extended table (lets call it MAIN TABLE) to contain the data for the following columns:

• User
• Product ID
• Product Location
• Additional information

We have a spreadsheet with multiple Product IDs and Product Location: Example:

Product ID	Product Location
0001	Lima
0001	Cusco
0001	Piura
0002	Chiclayo
0002	Shur

There are 1000 records and this can increate later.

So this is what we have done, but I think it is wrong because of the reporting piece.

We created another PRODUCT TABLE (no extended) with 2 columns, productid and productlocation.  We load the data to that table.  It works good

We used a Multiple Choice type on my record producer to look for the ProductID and only select the product location from a specific product location. So, if they select 0001, the product location will show, Lima, Cusco, and piura..

We thought it worked and everything, but when we create a report, it does not want to filter by productid or product location, it displays the sys_id.. which is weird...

I know something is not right because the product table does not have a Primary Key, it has multiple product ID, I dont know if I should create another table to only store product IDs, or what is a better way?

Thank you

[Basheer · Accepted solution]

Hi @AngelP83 ,

Go to the table definition of PRODUCT TABLE (not exteneded), navigate to the column productid and open its dictionary. There would be Display to the right part of the screen. Mark the display to true.

I hope you are reporting on PRODUCT TABLE, then the above thing would work.

If you are trying to report on other table, then go to that table and open the column which you want to show instead of sys_id and mark it as Display true.