Hey Guys,

This is my first time using a forum and I have a quick question.. in which im stuck on.

I have 4 fields, called ' Actioning officer , Responsible officer, Service, Depot '. They are all drop down menus, with the required names and so forth.

My Q is - If I select a name in the ' Actioning Officer '.. I want it to automatically give me the data for the other three fields.

How do I go by doing this?

Try this:

http://edoshin.skeletonkey.com/2006/06/linked_fields.html

But I'm not certain, if it really is what you, wish since there is an element of copying fields from somewhere to a new location. This is relational unhealthy, this means that you need popup menu's to change the shown value for 4 incarnations of the link ID, with the ID as such disclosed ...only popups can be made to work like this, drop downs won't.

--sd

Officers.zip

Edited June 12, 200718 yr by Guest

Wow, thank you so much !! I've just recently been using FMP and learning how to use it. I can do basics, but relationships etc .. I will still need my head around it, but with that attachment - that is exactly what I was after. Once again,

Thank you!!