Gabe Posted January 22, 2005 Posted January 22, 2005 Hey Im completely new to filemaker, so I am learning as I go. I figured out how they put the contact name in big grey letters on the contacts example. <<tablename::fieldname>> Easy enough. Now, I want to be able to display text based on a relationship. For example, I am designing a system to keep track of lawsuit records. I have a suits table, a parties involved table, and a join table which links what parties are involved in what suits. On the suit layout, I want to display text saying the name of plaintiff vs defendant. That information is in a related table, and I don't know how to access that using the table::field notation. I tried doing <<partiesinvolved::name>> but I want to be able to select which record to show based on whether they are plaintiff or defendant, and also whether they are the first plaintiff or defendant in the case, as there can be multiples of each. Is there an online guide to using that notation, or to applying dynamic text to a layout? Also, is there a way to use scripts to change or add text to the layout? Any help would be appreciated. Thanks.
stanley Posted January 22, 2005 Posted January 22, 2005 Gabe: An even simpler method is to use the field tool in the status area. Just drag a field into place, then in the ensuing "specify field" dialog, you can select the relationship in the pull-down menu and then the field in the box. Uncheck "show label" (or whatever it says) and there, now you've got your field. Now, with the field selected, you can control font, color, size, etc., and also in Format->Field Behavior... you can deselect the ability to enter into the field, thus turning it into a dynamic piece of related text which the user cannot modify. -Stanley
Gabe Posted January 24, 2005 Author Posted January 24, 2005 Well that does seem to be a better way, however, I'm still having basically the same problem. How do I specify which record to show in that field based on a set of criteria? Scripting? It sucks trying to do a project in a system I'm almost completely unfamiliar with. Thanks again for any help.
Recommended Posts
This topic is 7244 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now