Sync

[#1]

how to avoide Sync tables as i have a serious requirement of keeping almost 30 objects in one sheet. i m having 50 sync for that which may affect my data. please suggest.

[#2]

It will be great if you can provide more details with support data.

To aviod "Sync" , you can go for Qualify - Unqlify function , which you can eaisly get it from HELP.

[#3]

Qualify, I have used in SQL statements (at the time of creating the Qvd file) )but Sync are being creating while Loadind the Qvd files

[#4]

rename fields to you dont get any syns or create a linked table.

[#5]

No rename is not the solution....i intentialnaly want the relation between the objects. for an example:

Object A will ralate to Object B and Object B will ralate to Object C but i don't want to have any relation between Object A and Object C and this Sync is also created which is unwanted.

Clarify.....

[#6]

Nitin ,

Qualify - Unqualify provides filed name as "Tablename.fieldname" . So even after you use these functions if you are getting Sync is not just underatsndable . Are you sure youre tables names are different ?

Otherwise show your Data Model , i am sure your problem is not complicated .

Cheers,

Bhushan N