IEW Posted October 28, 2004 Share Posted October 28, 2004 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 Link to comment Share on other sites More sharing options...
transpower Posted October 28, 2004 Share Posted October 28, 2004 In a mass-update script for all your records: Set Field | highlight PartNo | 2 in Repetition box | Specify Calculation | AltPartNo Link to comment Share on other sites More sharing options...
Ender Posted October 28, 2004 Share Posted October 28, 2004 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 & & AltPartNo Link to comment Share on other sites More sharing options...
transpower Posted October 28, 2004 Share Posted October 28, 2004 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. Link to comment Share on other sites More sharing options...
Ender Posted October 28, 2004 Share Posted October 28, 2004 ...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. Link to comment Share on other sites More sharing options...
-Queue- Posted October 28, 2004 Share Posted October 28, 2004 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. Link to comment Share on other sites More sharing options...
transpower Posted October 28, 2004 Share Posted October 28, 2004 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. Link to comment Share on other sites More sharing options...
Ender Posted October 29, 2004 Share Posted October 29, 2004 ...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? Link to comment Share on other sites More sharing options...
IEW Posted October 31, 2004 Author Share Posted October 31, 2004 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7117 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 accountSign in
Already have an account? Sign in here.
Sign In Now