This is for me, so I can understand what you are talking about:
Contracts -< ContractProducts >- Products -< Purchases
Now, in order to show ProductName in a portal to Purchases on a layout of Contracts, you can either:
a) add a calculation field to Purchases = Products::ProductName;
b) append another occurrence of Products to Purchases:
Contracts -< ContractProducts >- Products -< Purchases >- Products 2
and place the field Products 2::ProductName in the portal
Thanks for your help.
I tried the Calculated field method and while I could see entries I could not add anything new to the field, just change the name of existing entries. This meant I could not use the layout with the portal as a working tool to manage the database data. I read in the Filemaker Pro Bible that this is normal behaviour for a Calculated Field.
I then tried to do your second suggestion, but I really don't understand what I have to do here... can you be a little more explicit please? I have for instance used the same link field for both Products -< Purchases and for Purchases >- Products2 but I'm a bit overwhelmed as to what do do next.
Can you help a little more, please?
I am not sure it's a good idea to change the name of product in a portal showing records from Purchases: such change will affect not only the current row, but the product record itself - and consequently all purchase records related to the product.
Maybe I'm using the wrong process then - I'm a newbie to Filemaker and finding it pretty convoluted. I'm used to MySQL!
What I really want is a way to enter and review the data for a client in a transparent way. That means I need info about the client, eg name and address, then about the Product, then about the Transactions for that product for that client - all showing in one layout. Do I need a different table structure or a different method of displaying it?