Jump to content

pop-up list help


orbit
 Share

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

Recommended Posts

ok i have to feilds name and address both in 2 diff files i want it so when hte click the field Name in file 1 they choose a name and it inserts it aswell as the corresponding address from file 2?

i have it so far so when they click Name in file 1 it inserts the name from file 2 but how do i make it so it also adds the address?

thansk

Link to comment
Share on other sites

Fair enough, but if the names *are* unique, then simply defining a relationship that matches the name fields, then defining the address field in file1 as a lookup would suffice.

If the names are not unique, such a set-up will still 'work' except that where there are two addresses against a particular name, the first will always be the one which is copied via the lookup. wink.gif

Link to comment
Share on other sites

Hi Orbit,

Ralph was suggesting that you use unique ID of some sort (eg a serial number field) in your second file, and use that to create the link between the two files, so that if there are duplicate names you will be able to distincuish between them.

Notwithstanding that, to set up a lookup, you will need to first create a relationship between the files.

To do that, go to the File menu and select the Define Relationships command. In the dialog which comes up, click the New... buttton, locate the other file, then in the relationship dialog, you will be presented with a list of the fields in both files, the current file in a column on the left and the other in a column on the right. In these columns you will need to select the fields that you want to use as the basis of locating a matching record in the other file.

Once you've selected a field from each list and closed the dialogs, you will need to go into the Define Fields dialog to set up a lookup. Choose the field you want to have the lookups occur in (eg the address field) and click on the Options... button at the lower left. In the options dialog, make sure you're on the Auto-Enter tab, and select the checkbox labeled 'Looked-up value'. In the reaulting dialog, you will then be able to select the new relationship from the menu at the top right, and select the field you want the value looked up from, in the list of fields which will then appear.

Once you confirm these settings, you'll find that when a new value is placed in the field (in db1) which is used by the relationship, a corresponding value (from db2) will be placed in the field defined as a look-up. In this way, you will be able to enter (or select) a name and have the corresponding address auto-entered into the address field. cool.gif

Link to comment
Share on other sites

This topic is 6522 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
 Share

×
×
  • Create New...

Important Information

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