Jump to content
Tondats Fuertes

Help me with the Value List Selection

Recommended Posts

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!

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×

Important Information

By using this site, you agree to our Terms of Use.