Solved

printing a record selected from a portal

Posted on 2004-08-25
3
337 Views
Last Modified: 2012-05-05
i  have 4 relational databases:
client (main database): fields: client #, client name
matter:                       fields: client #, matter #, name, description
file:                            fields: client #, matter #, file #, description
subfile:                       fields: client #, matter #, file #, subfile #, description

i am trying to print labels by pulling fields from all these databases.

in my client database i have a layout that asks for a client # in find mode. once the client number is accepted i have a portal that displays the subfile::matter#, subfile::file# and subfile::subfile# fields

i also have a print button that runs the following script:

Go to Related Record [Show only related records; From table: "Subfile"; External; Using layout; <Current Layout>]
Perform Script ["print label" from file "subfile"]
Select Window [Name: "subfile"]

when i click on the print button on a portal row, the script runs and i am switched to the subfile database and label layout.

the fields on the label layout are:
subfile::client#, subfile::matter#, subfile::file#, subfile::subfile#, subfile:: description
client::client name
matter::name, matter::description
file::description

my problem is that if i go to view, browse, list i notice that the client information and the subfile information is correct.
however, the matter and the file information is pulling only the information from the first record of the client in the matter database and the first record of of the client in the file database and not the corresponding information based on the matter number displayed or the file number displayed



0
Comment
Question by:kauakea
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
prifre earned 500 total points
ID: 11896976
Hi,

Interesting - I once designed exactly the same thing as you and I ran into the same problem. I solved it by using a special field that I modified before doing the printing and used that field with a different relation to get exactly whereto I wanted when I switched to the subfile.

The way it worked was:
1) You select who you are, and based on that a selection of records is shown
2) When the user clicked "Print labels", I had a loop that set a special "printfield" to a date.
3) I switched file and ran a script in the second database used a relation that related to the printfield to find the records to be printed
4) I printed the records, switched back and reset the printfield

at least that is somehow how I got it working.
The trick was when I found out I should use relations based on what I wanted selected between the databases. Then it was not too difficult.

good luck!

with a smile
/prifre
0
 

Author Comment

by:kauakea
ID: 11897138
i am fairly new at filemaker.
in which database is the special printfield located in and what would the loop look like.
this would be done on the different records located in the different databases based on the row chosen in the portal?
0
 

Author Comment

by:kauakea
ID: 11898188
thanks,
it was actually my relations that i fell short on. i only related the client # in each of the databases versus also relating matter#'s, file#'s between the databases. once i did this then the correct record information from each database printed on the selected label layout correctly.
thanks again for the insight on where i should have been looking!!
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now