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

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

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

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

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

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.