Jump to content

Auto Complete in FM7


This topic is 5667 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have attempted to auto fill a customer ID field (pK_memberID) in a new record layout for recording taxi trip details once I select the customer from a drop down list from the member table.

On creating a new trip record, I select the member and then I select the assigned driver. I can create finds based on customer or driver name but I would like to have the member or driver ID on the layour as well, although it's not necessary.

I know that FM8 has an auto complete function built in but I would like to know how to build a script that would auto fill the customer or driver ID field or for that matter any relaited data on the form from the selected member record, such as home address, phone # etc.

Mitch

Link to comment
Share on other sites

While you could do it that way, it's better to use the ID field itself as the relational key, and then just show the related Customer Name field on the layout. The selection then is done with a value list defined to show the first value from the related pk_MemberID field, and the second value from the Member Name field (you can sort by the Member Name if you wish).

The reason this is better is that relating by the Name alone can have problems when two distinct Members share a common Name.

Link to comment
Share on other sites

This topic is 5667 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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