Jump to content

Combining multiple fields into a repeating field


Chuck J
 Share

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

Recommended Posts

I'm using FM 6 on a Windows box.

I guess I didn't explain my problem fully.

I am converting from a DOS database. The database is student records. There are 15 fields in the DOS database that contain course names. There are 15 courses. Some students took some courses. The courses are not entered in the fields in any order. If I want to find which student took a specific course, I'd have to search for a course in each of the 15 fields.

I have created 15 fields for the courses in the FM database and imported the records. Now I need to import all the records in the 15 fields into one repeating field with 15 repetitions.

I know I can import a repeating field with each repetition as a separate record. I'm just wondering if it is possible to import the other way, separate fields into a single field, like perhaps when mapping the fields, map Course 1 into the Repeating field as Added Record, then map Course 2 into the Repeating Field as Added Record, how do I map to repetition 2. I don't think it can be done. Do you know of any way?

Link to comment
Share on other sites

Now I need to import all the records in the 15 fields into one repeating field with 15 repetitions.

No - now is it the right moment to hessitate, and study relational designs instead. What you need is a portal to show the courses and certainly not a repeating field. This is as classic as "Hello world" is for the c++ newbe, almost every book on the topic uses this problem as the introduction to a many-to-many structure, so grap whatever book on relational design/data modelling.

--sd

Link to comment
Share on other sites

This topic is 5756 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.