Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I gt six tables,
hav linked thm with a common key, also i hav created a calender for linking all the respective dates
but whn i try to link it with the calender table loop gets generated,
Hw to avoid tht loop, and hw can i link all the dates thn..
Please share some suggestions, hav attached the structure of the tables in attached file,
Most of the fields are common in your table just use concatenate to avoid the loop
Thanks Sivaraj for responding,
but the client is interfering in the data model he wants no concatenation, wants a common calender also
let me knw some logic to solve this.
anybody pls respond.....
Hii,
You can use link tables insted of concatenate I am attaching you sample demo for the same
create keys and link table.
Hope this help you
vikas
Also request you to send all excels so that we can help you.
Thanks for helping, i used the same concept but not the composite primary keys,
will do with tht approach later, first will deliver the output to the user..
Thanks