I have two protals Portal 1 and portal 2 linked to a file. In portal 1 I have the values a, b, c, d and in portal 2 I have the values 1, 2, 3, 4 I need to combine these portals in another file so that I will have a 1, b 1, c 1, d 1, a 2, b 2, c 2, d 2,.....

I cannot hink of a way to both sources of data for this.

In the main display I have a job number which allows me to link the 2 files. Can anyone help my brain is now fried with attempts.

Simon

If I understand you correctly, the values a, b, c, d and 1, 2, 3, 4 are all stored in the same file. So, all you need to do is create a joining field in that file, which links a & 1, b & 1 etc. If you need to join values from different records, however, you are going to have to create a self-link in the file. But once you have the joined fields in the first file, you can bring them into any file you want with a relationship.

Hope this helps,

Rigsby