Jump to content

Import into repeating fields


Mike Precious
 Share

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

Recommended Posts

I have a purchase requisition db in FMP5 with two tables, Req Header and Req Lines related on ReqNbr field. I wish to import these two related tables (979 & 4032 records) into one table with the Req Line records going into repeating fields. When I try, I am able to import the header records and only the first record for that header from the line table (Using matching records).

Is this possible to do? How do I do this? There are 1 to 6 req lines per req header.

Mike

Link to comment
Share on other sites

quote:

Originally posted by Mike Precious:

Kurt

The related files work fine within FMP5. However, there is a problem when I view a form with a portal (line items) in a browser. The form is displayed correctly but using "New Record", I can only add a new header record. The portal lines are not available in this view. This is not the case with repeating fields.

This is a problem with the way that the web pages have been designed. DO NOT adjust your database to make up for poor design of the web integration.

Without seeing the pages, I am not CDML literate enough to tell you exactly is wrong, but I'd bet that any CDML guru can do so easily.

Leave your DB relational, you will have more problems than you know what to do with if you use the repeating fields.

Fix the web pages.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

quote:

Originally posted by Mike Precious:

I have a purchase requisition db in FMP5 with two tables, Req Header and Req Lines related on ReqNbr field. I wish to import these two related tables (979 & 4032 records) into one table with the Req Line records going into repeating fields. When I try, I am able to import the header records and only the first record for that header from the line table (Using matching records).

Is this possible to do? How do I do this? There are 1 to 6 req lines per req header.

Why use repeating fields?

Add fields (defined as lookups based on reqnumber) in your reqline file to contain the related reqheader information. Then perform a relookup on reqnumber, this gets all the info into one file.

Create a LineItem database and import all of the repeating items into seperate records.

Now you have all of you reqheader and reqline information in a single file, each in seperate records and no repeating fields.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

Kurt

The related files work fine within FMP5. However, there is a problem when I view a form with a portal (line items) in a browser. The form is displayed correctly but using "New Record", I can only add a new header record. The portal lines are not available in this view. This is not the case with repeating fields.

Link to comment
Share on other sites

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