Jump to content

How do I "auto input" other details of someone after selecting a user


This topic is 7619 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi people.

I have this problem where you can select a product from a drop down list box. I have a Primary Key of a number for uniqueness of each product.

Instead of having to put in the primary key and then by pressing tab the related records for that product appears, I want the drop down list to be able, on when the user selects a product, to fill in related records including the primary key, detailed description etc.

This is probably possible (I hope). Hopefully someone's got an easy answer out there. There shouldn't be many problems since you are selecting a item which would be "unique".


Steve Griff

[ August 13, 2001: Message edited by: Steve Griff ]

Link to comment
Share on other sites

  • Newbies

Hi Steve,

You might set up a lookup to related records or a conditional value list might also solve your issue. Lookups use a relationship from your current file [Primary Key to the Primary Key of the related file]. Goto Define Fields>Select Options>Select Auto-Enter Tab> Select Looked Up Value Checkbox>Select Relationship>Select the filed you want to be auto-entered.

Conditional value list is much easier to set up in FMP 5>. Filemaker 5 CD has an example file and the help menu will aid you if I am understanding your post correctly.

Hope this helps you.


Link to comment
Share on other sites

This topic is 7619 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.