FileMike

Thanks, comment, that was helpful. Having a look at the file you attached and comparing it to what I had, it looked identical, however no data was displaying in the related field. I then realised that the Drop-Down menu field was referencing the wrong table (one that had a similar name and identical data), so after correcting that, the fields are now displaying as expected. I appreciate your help. Kris M, sorry, but I'm unaware of the 'FileMaker training series' you mention - that would be helpful. Perhaps you could be more helpful and link me to what you are referring to?

I have the Field 'Item_Reference' as a Drop-Down list, so I can choose the record from the other table - the field named 'Item_Ref'. If I add the Field 'Item_Material' from the related table, it shows an orange icon in the lower right corner of the field - telling me the field isn't related. When I choose a record from the Drop-Down list, nothing appears in the 'Item_Material' field. Have I failed to relate the table correctly?

Hi, I'm new to the forums, and I have a question that I hope someone can help me with. I'm sure its rather basic, but I'm pulling my hair out! I have a database with 2 related tables. In one layout, I would like to be able to choose a record from another table, and three fields from the chosen record appear as non-editable text in the layout. For example, I have 10No records in the Table ‘Resources’. Each record has a 4 fields: ‘Reference No’, ‘material’ ‘finish’ and ‘element’. In the Table ‘Schedule’, I have a layout where I want to create a record where I can choose one of the 10No record from the Table ‘Resources’ by selecting the record’s ‘Reference No’ and the other fields for that selected record (‘material’, ‘finish’ and ‘element’) are displayed next to the Reference number. I've tried using some functions, however I don't know how they work, and all the documentation I can find assumes one has already set it up... Hope someone out there can help! Cheers, Mike