selected name fills in address and phone

[robshortii]

Hi,

Can someone tell me if the following is possible.

I have an application that once filled out will generate a completed form.

there are fields for a doctors name and there address, phone and lic#.

Is there a way that when the drs name is selected, it will automatically fill in the address phone and lic#.

if so please tell me,

thanks in advance, Rob

[Barbecue]

There are several ways to achieve this.

Do you have a table of doctors that contains all the information for each doctor? If so, you can create calculated fields that refer to the values from the doctors table, or you could use lookup fields to look up the values from the doctors table. Or you could even use a script to get the information from the doctors table and put it into the proper fields.

Which method is best depends on what you're planning to do with the data and how the database will be updated.

[robshortii]

Hi Barbeque,

Right now I only have the fields for the dr and their info (address, phone and lic#). They have drop down menus so users can add the name and choose it from a drop down menu. But this can be cluttered when they start to add alot of drs name.

I thought it would just be easier to select dr name and have the rest of the fields filled in. I just dont know how or where to begin.

Thanks for any help you can give me. Rob

[Barbecue]

In order to do this you will first need to have a separate table of doctors that includes all of the information for the doctor, plus a unique ID number which is set as an auto-enter serial number.

Create a regular number field in your main table to hold the doctor ID number. Create a relationship from the main table to the doctors table based on the doctor ID number.

Create a value list in the main table that displays the Doctor ID number field from the doctors table.

In the main file, place the doctor ID number field on a layout, and format the field as a pop-up list or pop-up menu. Set this value list to also display the doctor's name as a second field.

Place fields for the doctor's name, address, etc on the layout based on the same relationship.

Now when you click on the doctor ID number,you'll see a list of numbers and names. Pick the one you want, and the other information will be displayed on the screen.

I have attached a simple example file that shows how this works.

doctors.zip

[robshortii]

Hi Barbeque,

Thanks for the help! I will be trying to do this...you made it seem easy, but I will mess it up somehow.

I am not to familiar with the terms used to describe thing in filemaker, is table a new layout or file. you mention drs table and main table.

thanks again, i am going to start working on that now.

Rob