macavity Posted November 20, 2000 Share Posted November 20, 2000 I have a script which uses dates entered into 3 repeating fields (10 repeats each) to create up to ten new records, each of which displays one set (ie 3) of the dates. Those three dates appear in the new records in a repeating field as well (with 3 repeats) Sounds easy, right? But: With "set field" dates are only copied into the first of the 3 repeats. Although the script includes instructions to copy dates into repeat 2 and repeat 3, they remain empty. Nor does the insert calculated result function work (result equals date), even when I change to the appropriate layout in the script. The only thing that does work is copying and pasting, which is an enormous hassle to program. Am I doing something wrong, or is this another FileMaker feature? Link to comment Share on other sites More sharing options...
LiveOak Posted November 20, 2000 Share Posted November 20, 2000 The first thing you're doing wrong is using repeating fields! . You're correct this doesn't work. The only easy workaround is to use a global date field. Set Field from the first repeating field to the global data field and then from the global date field to the second repeating field. -bd [This message has been edited by LiveOak (edited November 20, 2000).] Link to comment Share on other sites More sharing options...
macavity Posted November 20, 2000 Author Share Posted November 20, 2000 Thanks for the advice - I'll do that. I know using repeating fields is a mistake, but I'm stuck with them - the database has evolved from a much older one and I don't want to make major changes now. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8749 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