how to remove synthetic key

[#1]

how  to remove synthetic key present in this table where opn_stck is opening stock

i have created a link table ,but it gives a wrong output

[giakoum]

you need to find out which fields uniquely link your tables.

use only store code to link the showroom table for example. drop entity. If a store is uniquely identified by both store code and entity, create a composite key with the two and drop the rest of the fields.

Same for opening and sales. Looks like they are both fact tables, so concatenate them.

See attached for more guidelines

[ankitaag]

Hi Shweta,

Why link tabe is not giving you right result.

I suppose it is the good option. create keys in Item Master, Showroom, Sales and Opening table and link the same with keys present in Link tables

[ankitaag]

If you feel and find that concatenating Opening with Sales doesnt give you wrrong opening qty then yes, the best option is to concatenate these two fact tables

[vcanale]

Hi,

You can try to create a key field and join the two tables

[Anonymous]

I am looking for the best practices in QV. Thank for the documentations really useful.

Claudia