Brian Spolarich

I'm new to FM7, but familiar with relational databases. I'm stuck on how to get FM to do what I want. I have a relational database related to product manufacturing. Here are the tables and relationships: HPTC - Details on source materials. PK is HPTC_LOT_NO. RAD - Each RAD entry has a FK from HPTC. PK is RAD_LOT_NO. DEVIATIONS - Each entry has a FK from HPTC or RAD. PK is DEVIATION_NO. QC_RESULTS - Each entry has a FK from HPTC or RAD. PK is ACCESSION_NO. What I want to do is create a report that provide the complete details for a particular entry in RAD. This should include all of the relevant details from RAD (that's easy), plus a summary of all of the related entries in DEVIATIONS and QC_RESULTS. As a bonus, it would be ideal to only show the entries in QC_RESULTS where OOS (out of spec) == 'YES'. I know I can somewhat accomplish this via portals, but portals have a fixed size, and I want to provide a "print to PDF" report that can easily be distributed. I think I should be able to do this through using various parts and summaries, but I am not finding examples that help me and my tests don't yield good results. Help!

I don't see any evidence of an event-based model in FileMaker7 at all, so I would be surprised to see something like a script fired on field exit.

Thanks. I thought that's what I did. I tried it again and it worked. I used the self-join graph entries as the target. I think before I was using the table itself, and not the self-join reference. I'm not sure I understand FM7's relational model...it is kind of wacky.

I'm new to FileMaker but am very familiar with RDBMSes in general. I'm creating a database that includes both multi-table joins and self-joins. I've defined these relationships in the relationships graph. I want to show users on the detail screens for a given record other related records, either from other tables or the same table. For example, in the DEVIATIONS table, the REPORT_NO field acts as the primary key, and the RAD_LOT_NO and HPTC_LOT_NO are foreign keys from two other tables. I want to show the related REPORT_NOs from DEVIATIONS that share a common RAD_LOT_NO and HPTC_LOT_NO. So I add two portals to my layout and configure them. The related records show up by their REPORT_NOs. What I want to do is be able to click on the REPORT_NO in the portal and view that record. I specify the button behaviour in the portal to open the related record. This works fine if the related record is in another table, but if it is in the same table and view nothing happens (I keep seeing the record I have open). What am I missing here? FileMaker Version: 7 Platform: Windows XP