Help me with the Value List Selection

[Tondats]

Hi Filemaker experts,

Please have patients on me for I’m still novice with this Filemaker language.

I got two tables here: ServiceRequest and Customers

Service Request table contains sixteen(16) fields:
1.SRNo
2.Name
3.Account No.
4.Address
5.Meter No.
6.RequestService
7.RequestType
8.Remarks
9.Attention
10.DateTimeCreated
11.Receivedby
12.Notedby
13.Confirmedby
14.DateTimeAction
15.Actedby
16.Conformedby

Customers table contains four(4) fields and have 500 records:
1.CustName
2.CustAddress
3.CustAccountNo.
4.CustMeterNo.

The “Name” field as drop-down list under the Service Request table, I’m using “Autocomplete using Value List” for user to type the customer’s name and just select it. But the problem is, when I selected the customer’s name, the Account No, Address, and Meter No. will not automatically fill-up with their corresponding address, account no and meter no of the customer.

What I want is: When a user selected a Customer’s name from a drop-down Customers name’s list, the address, account number, and the meter number should as well automatically filled-up with the corresponding information of the selected customer in the customer’s name field.

Let say, If I selected the name “EDDIE GARCIA” in the drop-down list
Name               : EDDIE GARCIA
Account No.     : 
Address           : 
Meter No.        :

The Account No, Address, and Meter No as well should be automatically filled-up with the corresponding information of EDDIE GARCIA.
Name              : EDDIE GARCIA
Account No.    : 012-012-015
Address          : Brgy. 06 Jose Rizal Street
Meter No.       : 90806450

I will appreciate very much if someone can help me with this. Thanks!

[comment]

1 hour ago, Tondats Fuertes said:

What I want is: When a user selected a Customer’s name from a drop-down Customers name’s list, the address, account number, and the meter number should as well automatically filled-up with the corresponding information of the selected customer in the customer’s name field.

What you want can be accomplished using a lookup based on a relationship matching on customer name.

However, there are two problems with what you want:

•  a customer's name may change in the future, breaking your existing links;
•  a customer's name may not be unique.

Consider basing your relationship on customer's account number or ID (an auto-entered serial number in the Customers table). Then use a value list where the name is the second field. Or - preferably  - use another method of selection (e.g. a portal) that would allow the user to easily choose from customers with the same name by some other attribute.

[LaRetta]

Hi Tondats Fuertes, welcome to FMForums!

Everyone here on FMForums understands what it is like to be new to the field; we all were new at one time. :-)

Comment has provided the best advice you could possibly receive.  I'm posting simply because I want you to know that I appreciate your well thought-out post - it makes it far easier to help someone when posts are written in such a clear, concise manner.

[Ron Cates]

Somehow I can't imagine Comment was ever new...