AnsweredAssumed Answered

Auto populate a field when selection made in Drop Down List

Question asked by benpwallis on Jan 6, 2010
Latest reply on Jan 6, 2010 by benpwallis

Title

Auto populate a field when selection made in Drop Down List

Post

FM PRO ADV 10.0V3

Mac OS 10.6

 

Hi,

 

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

 

Hardware Software

Presales

 

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.

 

Thanks

Outcomes