Promt data 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.

I'm running it on windows 7.

My Problem:

I Used the Contact Management template to create a customer registration database and a Hotel List Database.

I changed the values so they would fit for my use.

Now, in the customer registration database, I've got "current_hotel" and "Hotel_number" as scroll down lists. I manage to link the "current_hotel" to my second database, hotel list, to display all "Hotel_name_sort1" as the options for this list (all hotels i add to the database). But I also want the "hotel_number" in the customer database change to the "hotel_phone1" from the hotel list database at the same time. i.e If i select Hilton in my customer database it should also change the "Hotel_number" to what is written in the "hotel_phone1" in the hotel list database.

Hope you understand what I mean and would be very glad for any help I can get.

Thank you!

/Fred Young

[Matthew F]

Welcome to FM Forums!

As a reminder, you should not double post your questions. Its better to edit or add an extra posting on your original thread.

For my answer to your second posting go here:

#345485