×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Detail in PO not Working

Detail in PO not Working

Detail in PO not Working

(OP)
Hi,

I am trying to build a PO form for misc. products, I am using 3 tables Vendors, POH and POD, I got it working in the input of data, but now I need to print the actual PO, but it only prints one line item per PO number.

Can someone help me, I have tried everything.

Norm.

RE: Detail in PO not Working

Norm,

Your question is light on information but I'll make some assumptions based on Filemaker FAQs.

Most FM novices attempt to print their Purchase Orders (or the like) from the header table.  The correct way is to print from the LINE ITEMS or DETAIL layout.

If you print from the header table the best you could ever do is print the same number of lines that your portal displays.  If printed from the LINE or DETAIL table you will be able to print an unlimited number of lines and the header information can be included and it works out just fine because the header is exactly the same for each line.

Does this answer your question?

-Striker

RE: Detail in PO not Working

(OP)
Striker thank you for responding so quickly.

Let me see if I understand what you are saying, On the layout where I am designing the the full PO, it should be driven by the POD and not the POH.

Norm.

RE: Detail in PO not Working

Yep.  Design your print layout from the perspective of the details (POD in your specific case).  You will be able to include POH fields in the header & footer sections.

Generally speaking, your users will do most of their work on a layout that is based on the header table.  When it comes time you print you will create a script that first  switches to the print formatted layout (based on the POD) and then find all records that are related to that particular PO.  Finally you will print and then return to the original layout.

-Striker

RE: Detail in PO not Working

(OP)
Striker:

It worked ok on the input but know I am want to print the PO with it's POD "detail", Ived designed the layout like so:

Layout is divided in three Header/Body/footer
on the header I have all of the POH info. on the footer the grand total and notes with is part of the POH, now the body has a portal and the POD fields so it will display multiple lines of the detail of the PO in question, it displays OK, but, if the PO has more de 13 lines of detail it should jump to a second page, which it does but the Grand total is in both pages, also if I only have 2 line items on the PO, it will still print 2 pages.

I hove my lengthy explanation will help you on helping me get out of this situation,
Norm.

RE: Detail in PO not Working

Norm,

You shouldn't need a portal at all on your print formatted layout.  Remember, your layout should be based upon your PO Details table occurance.  You can confirm this from the LAYOUT MODE by choosing:

Layouts > Layout Setup

In the "Show Records From" box you should see your PO Details table occurance.

You will also want to ensure that you view the layout as a list:

While in the BROWSE MODE pull down:

View > View As List

You should shrink the vertical dimension of the body section so that it is just slightly bigger than the fields that it contains.

Lastly, the only way to preview the results is to go into the PREVIEW MODE.  Pull down:

VIEW > PREVIEW MODE

Fundamentially speaking, portals are for viewing *many* related records from the *one* side of the relationship.  In your case you will probably have a portal on the layout that has your PO Header information because there can be many PO lines for 1 header.  You would normally not have a portal on your line item layout because for any given line there is only one related PO header.

-Striker

RE: Detail in PO not Working

Oh yeah... I assume you are on FM version 7 or 8.  If you are running an earlier version then my explanation *can* be confusing.

-Striker

RE: Detail in PO not Working

(OP)
TStriker:

I agree with you, but I need to display and print the PO for a customer, not a report of PO's, "One to Many", is there a formula that I can use for this Like a FOR or an IF statement, at this point with your info. I see everything, when I need to see one PO and it's detail.

Thanks Again.

Norm.

RE: Detail in PO not Working

Norm,

I assume you have a PRIMARY KEY field in your PO header table.  It is probably called PO_Number or something like that.  You should also have a field in your details (aka lines) table also probably called PO_Number.  This serves as the link between the header record and the detail (line) records.  What you need to to is navigate to your print layout (which is based on the detail or line table occurance) and then do a find for all records that match your PO Number.  For example, to do this manually you would jot down the PO number that you want to print.  Let's say it is 1600 for instance.  Then get yourself over to the print formatted layout.  Go into the FIND mode.  Type 1600 into the PO_Number field and then press enter to execute the find.  It should now show a list of all PO lines that are related to PO 1600.  If you go into PREVIEW MODE it should show you an example of what your printed PO should look like.

To script the whole operation there are a few ways it can be done.  One way is to script the find using essentially the same steps that I explained.  Another way is to use the GTRR (Go To Related Record) script step.  You should see if you can do it manually first before attempting to script the whole process.

-Striker

RE: Detail in PO not Working

(OP)
Striker:

It works on the Browse mode, but now I need to print the PO, if I move to the Preview mode I only see one line of the detail, and if I print from the Browse mode there are two options, RECORDS BEING BROWSE "It prints al of the PO not only the one I want, and CURRENT RECORD "it only prints one line.

PS: Thanks for all your help.

Norm.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close