I have a file with financial transactions and another file with each item of the financial transaction. The items can be a product or a service. A financial transaction can have some products and services.

I have a portal in the financial transaction file where I can see every item of the financial transaction. For example: I have a record in the financial transaction file that has the ID 10. There are 3 items of financial transaction, that are: 2 products and 1 service.

In the portal I already have, I can see these 3 items, but I would like to have 2 separate portals, one for products and one for services.

I thought it would be possible by making 2 relationships, one with the ID & Product and another with ID & service. But it didn

Actually, I think you were on the right track with two relationships, so perhaps if you told us how you approached we could have some specific advice.

In the Items dbase, I assume there is a field with either "Product" or "Service" in it? Then in Transactions you can have two calc fields:

ID & ".Product"

ID & ".Service"

and in Items have just one:

TransactionID & "." & ProductOrService

So the two relationships are both of the first two fields connecting to the same field in Items.