Several fields between 2 databases

[Fred Young]

My background:

I'm brand new to Filemaker Pro and I just got version 10 from my boss. I'm know HTML and Java but don't know to much about databases. I been playing around now for about 3 days, starting to get the very basics.

My question:

Database1.fp7 got 3 fields, (Name, Number, Street).

Database2.fp7 got a scroll down list, where i manage to list all the "Name" from Database1.

How do I make the "Number" and "Street" to automatic come in to Database2 from Database1 from the right record depending on what "Name" i pick in the scroll down list?

I don't know if I need to do a relation or calculation or whatever is needed, can someone help me or at least point me in the right direction?

[Matthew F]

Firstly, its easier to create two different tables within a single database file, rather than to create and maintain a relationship between two different database files. For example, if you move one database (and not the other) then your relationship links will be broken. Also, if you setup user privileges, this will need to be done repeatedly for each database.

It sounds like you have created Drop-down list showing the 'Names' from Database1 in Database2. You also need create a relationship between Database1 and Database2 using 'Names' as the match field to connect the two. (Or if you follow the advice above, use 'Names' as the match field between two tables in a single database).

You can then place related fields from Database2, such as 'Number' and 'Street' on a Database1 layout. Or if you expect the same Name to show up more than once in Database2 then put the related fields in a portal so you can view all of the related records.

[Fred Young]

Firstly, its easier to create two different tables within a single database file, rather than to create and maintain a relationship between two different database files. For example, if you move one database (and not the other) then your relationship links will be broken. Also, if you setup user privileges, this will need to be done repeatedly for each database.

It sounds like you have created Drop-down list showing the 'Names' from Database1 in Database2. You also need create a relationship between Database1 and Database2 using 'Names' as the match field to connect the two. (Or if you follow the advice above, use 'Names' as the match field between two tables in a single database).

You can then place related fields from Database2, such as 'Number' and 'Street' on a Database1 layout. Or if you expect the same Name to show up more than once in Database2 then put the related fields in a portal so you can view all of the related records.

It worked!

I got it working! Thank you a million times! I've been sitting for 12 hours trying to figure this out and I was as simple as that!

Thank you!