Solved

printing a record selected from a portal

Posted on 2004-08-25
3
340 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

828 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