2007 Sep 18 5:46 AM
Hi Guru's,
My question is that how to find the linking table between two fields. It's a generic one not specific. I have tried to put and conditions in data element and wanted to use where-used list, it didn't work. We came to know across two fields and we have no idea how to link them what is the shortest method to find the linking table.
One way out is to find the tables needed for one field in excel column, for second field in another column and then use VLookup. Is there any shortcut method or any system functionality which can be used to get the output.
Regards,
Mallick
2007 Sep 18 5:51 AM
You can find by using in where used .
If you can let us know the two fields, so that we will try helping you to find the table names.
2007 Sep 18 5:54 AM
I want generic solution not for specific fields.
Thanks,
Mallick