Jump to content
Sign in to follow this  
IEW

Repeating Fields, populating and find

Recommended Posts

I have a table that has a "PartNO" field and a "AltPartNo" field. I want to use a repeating field to do a find, looking at both the same time. The best way to do this is use a repeating field for "PartNO" and put "AltPartNo" in the repeat. Question is "How do I populate the 2nd part of PartNo" with "AltPartNo"?

TIA

Ivan

Share this post


Link to post
Share on other sites

In a mass-update script for all your records:

Set Field | highlight PartNo | 2 in Repetition box | Specify Calculation | AltPartNo

Share this post


Link to post
Share on other sites

I don't know what transpower is trying to say, but if this field is just for searching, I'd advise keeping your fields separate and using a calc field for searches (or relationships)???

PartNoCombined (calculation, text result) = PartNo & par.gif & AltPartNo

Share this post


Link to post
Share on other sites

The poster currently has a separate alternate part number field. It would be more convenient for him to put one value in the repeating field in a find layout to find either the main or alternate numbers; this simply saves a second find request.

Share this post


Link to post
Share on other sites

...this simply saves a second find request.

but adds to his file maintenance. Using a multi-line calc provides the same search capabilities without needing scripted repopulating in the future.

Share this post


Link to post
Share on other sites

A calculated repeating field with two repetitions equal to Choose( Get(CalculationRepetitionNumber) - 1; PartNo; AltPartNo ) would also work. But I would assume a multiline to be faster. However, this is a nice technique to use when indexing limits become an issue. Of course, with FM 7 it would be much rarer.

Share this post


Link to post
Share on other sites

Thanks, -Queue-, as always.

Ender: I assume that the script would be run just one time (so no other file maintenance). From here on out, the poster would enter both the main and alternate numbers in the repeating field.

I think this is a situation where one repeating field is better than two separate fields.

Share this post


Link to post
Share on other sites

...the poster would enter both the main and alternate numbers in the repeating field.

You want to limit your options on the UI for those fields?

Share this post


Link to post
Share on other sites

Thanks for all your input. Mass updating the "partNo[2] with "altPartNo" at one time is no problem, I just used the replace function. The search function works great using the repeating fields. Now comes the problem of a new record, copying the "altPartNo" field to the "PartNo[2]". I can't find any way to do this. Probably will have to remove "AltPartNo" field and replace with "PartNo"[2], this looks like the right thing to do.

As usual a great job from the Gurus.

Ivan

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
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    john9210 
×

Important Information

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