Auto populate a field when selection made in Drop Down List
FM PRO ADV 10.0V3
Mac OS 10.6
Sorry for probably what is a noob question but it is from a noob user!
I have a drop down list and what I would like to do is set something up that when I select an option from the drop down list it will automatically fill another field in from another list.
For example if I have the following in a drop down list
I want another field to automatically populate with predetermined fields ie if I select Hardware Software I want to call another field
Hardware Software (selected from drop down)>Would call (All physical aspects of a device........) from another field.
I beleive this can be done with creating a relationship to another table but I tried this and really could not fathom it.
Any help would be greatly appreciated and if it could be explained in simple steps that would be great. Im technically minded but new to databases.