AboutJamey Key Expertise NEW and INTERMEDIATE USERS. WHAT CAN FILEMAKER PRO DO FOR ME? I have been using FileMaker products for over 10 years and have basic knowledge in all areas of FileMaker database set up and use. I`m not prepared to answer questions about complex situations or calculations but can help beginners and intermediate users set up and use FileMaker databases.
Experience Have been using FileMaker since 1989 in our business. We have 10 users on the network who use these databases every day. Our largest databases have had over 30,000 records at one time. In 1995 one of my files was chosen as "Most Unique Database" in a contest sponsored by Claris, maker of FileMaker. Recently I have developed a set of files for new computer system installed at our church.
Expert: Jamey Key Date: 7/15/2008 Subject: Is it possible?
Question I've created 3 file, Quotation, PO and Invoice. In Quotation file I've created field name PO No. and Invoice No. to put PO No. from file PO and Invoice No from file Invoice in each page of Quotation. When I open Quotation file, I want it to link me to PO page or Invoice page which same No. in Quotation page record in one click. Is it possible?
Answer Dear Tan;
Yes, it is possible to do that. I would recommend you have a field in Quotation called Quotation_ID, in PO have PO_ID, and in Invoice have Invoice_ID. These will allow you to see related records from another file in each of the files.
Set those up, then email me and I will help you see the related records.
