pop-up list help

[orbit]

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

[RalphL]

Unless you have unique names, you can't. You might want to consider using a name ID field. Then you can use either a related field or a lookup based on the relationship to the name ID.

[CobaltSky]

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.

[orbit]

explain some more plz im a lil newbiesh

[CobaltSky]

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.

[orbit]

thanks works now

[orbit]

ok thanks