What you have selected all looks correct. The next place to check is the design of the layout.
The layout, I can see is based on the Official Receipt table occurrence as would be expected here. But from what table occurrence are the client fields on your layout selected? Click each one while in layout mode and check to see what name appears to the left of :: in the Display Data From box on the Inspector's data tab. You should see: "Clients for Invoice Printing", but I suspect that you will see "Clients". Change them over to "Clients for Invoice Printing" and they should then display the correct related client info when you select an ID in the fk field.
Hi Phil thanks very much for your help and response. I have double checked what you suggest and the fileds are all from the table occurance of 'Clients for Invoice Printing' (the copy of the Clients table occurance) except for the __fkClientID which is from the Official Receipt table occurance which in turn is the one the layout is based on. I have exactly the same set up and field matches between the Client occurance table and Invoice occurance table which works fine. One thing I realised I haven't made clear initially is that I can't get anything to show in the __fkClinetID field - it should be a drop down menu which would allow the correct match field to be selected so that the other fields will populate. However I can not select anything in this field and it remains blank so I was thinking that it maybe the way I have set up the drop down menu in regards to the field. In the same set up on the Invoice layout I can select the Client via a similar drop down menu........... Any further thoughts would be greatly appreciated. Regards
Yes, if you can't get a value list to appear then something is wrong with your value list. The setup you show, however, looks correct.
Well I finally fixed it - I found an old post where the suggestion to fix a problematic Drop Down Calendar was to delete the layout and do it again. So I deleted the layout, created a new one and imported all the fields again and it works. Thanks for the help Phil. Best regards - Richard