Relationships

I've got two tables, one that stores Contact records and another that stores a list of scheduled Meetings. Each meeting is related to a single contact, and a contact can be related to multiple meetings. What I'd like to do is create some kind of layout that lists all of the contacts that don't have any meetings scheduled. I come from an SQL background and running a join/select statement to do this would be pretty straightforward, but I can't figure out how to do it using FM. Any thoughts?

What are the general principles and relationships involved in creating a "Join Table?" I am re-writing a solution from FMP5.5 in FMP7 and have been told by FMPtech support that I need to create a Join Table to report summaries in the way I desire. In FMP5, I was able to use a summary layout sorted by my criteria to display summary fields from 2 different related files. I would find the record set and sort it in each file, then display summary fields in the appropritate part of the layout and in preview mode the summaries would calculate accurately for each. (Mostly counts, sums and averages.) In FMP7, however, both (old) files and now tables within a single…

I was hoping someone might give me a heads up on a few points.. IN naming files,scripts, etc... Are there any specific no-nos? For instance, I'm naming my actual database files in all caps..such as MEDIA LIBRARY...I'm putting in things like CLIENT::VIEW MEDIA for layout names..etc..etc. Are there any particular conventions I should be aware of...looking for optimal cross compatibility of course...WIN, OSX and OS9.. Secondly, in table view is there a simple way to create a graphical link to a record's form view? I want the client to be able to click on a button that autosorts the records and upon displaying them in list view provides a graphic link to each individual …

i work at a nonprofit and have downloaded a filemaker database that is used to track donations. At our company there is a Master List of contacts that is updated by one person in the company. I would like to use the templates from the downloaded database for all our donation tracking information but would like to access the names and addresses from the company's Master List. the Master List has about 10,000 records each with a unique identifier number. i have created the field for the unique id in my donations database and set it up as the matching field but what i don't get is how to get my donations database to grab all 10,000 of those records, and add the new reco…

I want to create a function in which we can track the last modified date, time and name in a specific file in a database. We currently have modified date, modified time, and modifier name fields (updating as auto-enter definitions) in the file itself, but we want these to show through a portal as a "history" sorted by decending date. Is there a way to set up an external file so that each time a record in the specific file is modified a new record is created in the relational file that tracks the last date, time and modifier name? Using FM 5.5. Thanks for any suggestions you might have. -Matt Norwood

ok, I have this post going on the Script Maker board, because it started out as trying to make a script, but I moved it here because someone advised me to use Relationships. I'm using FMP 7 to create a computer inventory. The identifier is a number assigned to each computer. Something that the person I'm doing this for wants is to have each computer entry list all the work that has been done on it. Now, if it was just one job per computer, this would be easy. But they want each line to list EVERY job, so I need to define an easy way to create new fields when the user wants to add a new job. I was trying to make a script, but there is no way to define new fields …

Okay, I posted before regarding getting one DB to handle multiple projects. I've added a ProjectsDB with solely project information (name, location, number, etc.), leaving a ContactsDB and a UserDB. The UserDB is where all the work is done. It's related to the ContactsDB for contact look-ups and the ProjectsDB for project information. What I am trying to accomplish is that when a user opens the UserDB, they have to select what project they intend to work on, then not only will all other project records be omitted, but the ProjectDB info will auto-populate all new records until the project is changed. I have a value list in the UserDB coming from (linked from) th…

Lets say... We have a table "Companies" ...and another table "Customers" -one company can have many customers I want to show (in Companies layout) the related customers in a portal. The problem is that I want (in the same portal) the customers in fixed groups of 20s (no scroll bar) I want to clik a button "show me next 20" and the portal show the 21 - 40 customers then clik again and the portal show me 41-60 customers.....etc any idea? please... *sorry for my bad en

Hello all. Have learned much from these forums but now have a problem I can't seem to resolve. The applictaion is conceptually simple. I need to keep track of a student-athletes health history for a university's Sports Medicine dept. In August, a student fills out a 90 question Yes/No form relating to their health history (e.g.Have you ever had a knee injury? If so define dates and details. ) I would like to present the student with a set of layouts containing multiple questions, but only save the question and the comment for the "yes" answers. I have 3 tables Student table (wtih demographic info) Health history table (which contains the que…

Hi everyone, Wondering if you could offer some help to my woes! I currently have a relationship which is defined on an index number of records. This is a one to many relationship. Basically, for any record, you could enter any number of associated payments and dates. For any record,the associated records will have another number (not unique to the record but consistent across all of its associated records). I have two questions regarding this scenario: Firstly, how can I make it such that this second non unique number is forced to be consistent across all of the related records? Secondly (and significantly more importantly!), I wish to take all of…

Project for a touring company. This involves a few files: Trip Master, Clients, Hotels Issue - How to report the clients for each hotel, associated with a trip, when all the hotels share the same trip code (I can add unique ids) I need to create this report in the client db, because there is a lot of special sorting that goes on to get them to appear in the correct room order. But I can't find a way to move from one hotel to the next, throughout the trip, showing the same client list. (Except when I run the report from Hotels using a portal, which doesn't allow me to sort the names and add formattming separating them correctly) I have tried join tables, …

I don't even know where to start searching for this information. I would appreciate being directed to an answer or any help in formulating my own. Scenario: I currently have multiple projects (I am a builder) and each project currently has a separate Project DB linked to a single master Contacts DB. I would like to have one DB that all users can use, where the user selects which project they are woking on and all relationships change to the Project DB and all current and past information is available to the user. They can then switch to another project. This would be to avoid cross contamination of DB's. I also have auto-enter text fields with the project's…

I have a pref file called constants which I am using to store email templates etc. The constants file contains a ID field which is a calculation = 1 and this is linked to a calculation field = 1 in the contacts file as a relationship so that all the constants appear for each of the contacts. However I want to add to the email either a formal or informal greeting Dear Mr Smith, Dear Simon. So I added a field to the contacts called ToEmail which is a calculation based on a drop down (formal or informal) which is fine. However when I want to send the email I want to send a text field which is the combination of formal/informal greeting, body of the email and a sig…

I have a bit of a dilemma: I have a parent database for work orders. One of my fields is a calculation Sum(timesheets_rel::hoursworked) ... This gives me an instant running total when I view a particular record (I really like that part) .. the relationship is based off of the unique serial number of the work orders. I look at individual records every day, and it's useful that it's a unstored, non-lookup field. HOWEVER, I need to run a report on a monthly or bi-monthly basis (or so), and I need to make calculations based off of that Summed value. Any suggestions?

I'm kinda new to Filemaker. I'm trying to write a simple report card thing for my mom. I have a few tables, one is for students and it has all their contact info in it. One is for the actual report card. I have the students table linked to the report card table on StudentID, which exists in both tables. I'm trying to write a script that when a new student is entered, a new blank reportcard is created for them that is linked to their studentID. For the life of me I can't figure this out. I looked on the boards and found some stuff about Portals, but honestly I'm kinda lost as to what those do besides display related info. Any help would be really appreciated. Than…

Hello, I hope I can explain this well. I have created a small test inventory database to track the sales of certain products. I have 2-tables one is a list of all my products and each record has an auto-index number. The second table is only my sold transaction info (QTY, Sold Date, & Sold Price), this table also has it's own auto-index number. I used the field "product ID" in both tables to join and form the relationship. The 'Product ID' in the products table is the autonumber and the 'Products ID' in the 'sold items' table is the related field. On my main layout of products I created a portal to the 'sold items' table and have a list of 5 rows with a scr…

I have a sort of abstract question about relationships. Ok, say I have one database containing 2 tables. Each table has 2 fields. For example, say table1 has firstname, lastname. Table 2 has lastname, IDnumber. The tables are linked by last name. Ok, here is the question. Say I create a new record in table1. Create the last name of Smith, first name Jen. If I want to give Jen an ID number, I have to create a new record on table2, with lastname = Smith and an ID number. Is there anyway that I can assign an IDnumber to Smith without having to manually create a new record in both tables? Say I am viewing in table mode, looking at table1 with the fields firstname, …

Is it possible to create a self-join relationship within the same file to display all the records of that file in a portal? I want the portal because I want to use navigation buttons on the left side of the screen and you can't do that in list view. I've tried to create the self-join, by matching one field with the same field in a second occurance of the table: Projects to Projects 2. Not sure where I'm going wrong. I got it to work once, which is puzzling. Gordon

Hi all..I'm new here..so far enjoying this forum. My problem is that i have 1 database with inventory and other for inputs in the inventory, ex. we buy 1 toner for epson and we introduce it there. Question is how do I, in inventory, sum the records entered for tonner epson to keep the inventory updated. Using sum, it sums all entrys not only epson toner. Maybe its very simple...but not getting there. Thank you in advance to any that can help.

Hi, I'm brand new to FileMaker, but years ago worked extensively in SQL and have dabbled in Access a fair deal. I understand one-to-many relationships fairly well, but I am bamboozled by layouts (are these what people call portals?) in Let's say I have two tables, PhoneBook and PhoneBill. PhoneBook has two fields, Caller and Called. Called is specified as unique. PhoneBill has two fields, Called and Cost. PhoneBill::Called is linked to PhoneBook::Called. Due to PhoneBook::Called being unique, I (think I) have a many to one relationship. It shows up as such in the relationship diagram. Now, I have created a layout BillView based around PhoneBill, showing Phone…

Hi you all there... This is my first post here...in my best english ;-) We have a content-/productinfo management system running on FM7. In our so-called mainmodule is all the core product info. In a related table is all the product-image info incl. link/preview of the images available on our OS X server. Unique id is ofcourse the "article code". I can see all related images in the mainmodule (I made a script copying the article code into the image-linkfield;all images have the articlecode+ a suffix as name: D1412.eps + D1412_detail1.eps)). When I make an export from the mainmodule I only get ONE image link; the one who is activated (by script)in the related portal. …

I have a sum calculation that's behaving a little weird on me. The calc is a simple sum of a related field: sum(shipments::units). The relationship is based on a code and on a boolean received field. Only shipments that have been received are related. If I change the value of shipments::received the sum changes correctly, but on one of my layouts the fields don't refresh and on another one it does. At first I thought it was that one was in list view and the other was in form, but after doing some testing I figured out what the difference was: the layout that refreshes has a portal on it showing the related shipments, the layout that doesn't refresh only has the sum. …

I have a portal in my DB. I want to put a button in the portal so that it will show up on every row. I then want to assign a script to that button. This script will run in the parent file, not the file being shown in the portal. Is there a way that when I select the button that I can have a different script run depending on which portal row is being selected? Larry

Hello, I am trying to figure out the best way to link contacts to other contacts when they are in the same contact table. Any suggestions?

I have been importing records of organizations and people that is aimed to creating a contacts database. I have several tables with different kind of contacts (such as churches, schools, businesses, etc.) Some of the contacts are actual people with out an organization attached to them, and some of the contacts are just the organization without contact names attached to them. Some have addresses, phone numbers, & emails. Some contacts have all or no addresses, phone numbers, or emails attached. I can't find any field to make the primary key so I can tie up the relationships between the tables. Should I create a "contact number" to identify, if so, how do I do that now …

Hello, I have a simple relationship question. I have 1 main table with about 20 childs. How does FM handle relationships across children? Is it better to link to children than to the main database (stability and speed)? Any suggestions? Thank you.

I can't seem to create new related recorded in a related table. I have a main table of employees which relates to another table of events. I have a button where the user can click to create a new event for that employee. In FM 6 I used to run and external script in the related file to create this new record and populated the related fields using globals. I have to believe there is an easier way with FM7. However, now I can't figure out how to just create the related record since I am using tables and not a separate file anymore. Thanks for the help. -Kevin

For a class-enrollment application, I've got a set of classes that sometimes have multiple teachers and always have multiple students, i.e. two many-to-many relationships with join tables. One of the requirements is for a grouped-data report that's supposed to look basically like this: sub-summary by teacher sub-summary by class names of enrolled students & related data The idea is to get a printout for each teacher showing all their classes and which students are enrolled. The problem is that if I do the report with "Show records from" set to the teacher-class join table the report shows only one student per class. If I change "Show records f…

I have a database for scheduling work. Most work is scheduled in meetings, and descriptions, due dates, etc are generated manually. However, a certain amount of work is preventative maintenance; so it reoccurs on a weekly, biweekly, monthly, etc. basis. So, I have a database for work orders, and a source database for Preventative maintenance tasks. All of the records in the PreventMaint database are "generic", that is they are a description I want to write a script that loops through all of the Preventmaint database's records, calculates which tasks are due, and creates any necessary records in the work database. No problems on the calculations to separate what I n…

I created a simple database. This contains recipies for chemical solutions. Within this database I want to link records belonging to each other. So I defined a fild releated records and wanted to create a lookup to show the records matching to this field. Here comes my problem. I am not able to do this because the field I want to be coppied belongs to the relationship. Is ist better to create a script? Which commands are neccessary to use? I have no idea about this. Thank you for you helpful ideas.

Hi, I've created a separate related DB to hold field titles (text labels) for various language versions. The match field (number, indexed) in the master file contains value 0,1,2 or 3. The related file has 4 records each containing one of these values in the match field. The field titles work properly, when the value in the match field is 0,2 or 3 (eg. show the correct corresponding value from the related file), but when the value in the main file's match field is 1, then all the related fields in the master file also show just "1". (instead of the values in related file's record holding 1 in the match field). Any ideas why this is happening? Jari V

Ok- this is going to be tough to explain! I have a database that is used for storing data about a large collection of images. Among others, I have a table that contains our category heirarchy system. For example: a photograph of the Guggenheim museum would have a "category" = Architecture, a "Worktype" = Cultural Buildings and a "SubWorktype" = Museums. There are currently 450 different configurations like this (ie 450 records in my table). So, in my main table (records for each image) I currently have it set up so that you select each of these fields from lists that are pulled from the table. But it would take up much less space if I could just selec…

Hi, first I'm a serious newbie - please treat me like an idiot! A doing a db to write school reports with. I have a table of report comments (fields include gender and rating) and a table of students (fields also include gender and rating). I can enter into each kids report by selecting comments from value lists using fields from comments table, but there are loads to choose from! Can I filter just the relevant ones (e.g. only male comments if gender field is male)? How? Many thanks in advance!!

I have a database where i will be entering payment information and I want to be able to potentially enter multiple payments for a single invoice. It won't necessarily be the same every time etc. I want to basically create a table off of each of those files but I don't know what to do! Im a complete beginner to this, so any help would be great. Thanks a lot for your advice, Jim

Please relay if there is a place on the web that would help show me how to accomplish the following? I have two databases.... 1st database has all the zipcodes in MD, DC and VA with the correct corresponding County for each. ( two fields ) 2nd database has multiple addresses with zipcode for each...but county field is empty... You guessed it, I want the 1st database to be referenced and have the correct county show on the 2nd database. Whenever I import new records into database 2, It would the correct county just show up.....then I could export the records and have corresponding counties included for each record. This way, the relationa…

I have two tables in my database. Both have two fields: technical name (tn) and common name (cn). The "lookup" table has only these two fields and is used to populate the common name in the main field. The link is with tn fields. The "main" table conists of the tn text field and the cn calculated field defined as: if(tn=translator::tn; Translator::cn; "?") The results are to print as text The calculation copies successfully about 50% of the time, tho when it does, it always displays "?". Thinking it was typo problems, I cut and pasted from one the technical field from one table to the other so I know they are identical. There is no appeara…

how can i show the records of a table (T1) in a table view (for example with a portal) in a layouts (LT1) that the table (T1) is the source of it's (LT1) records.

Attached is my attempt at making a many-to-many relation - question are: 1. What is a good way to make a unique Id other that having incremental numbers 2. Does anyone have any ideas for making the adding of a company to a contact more slick? 3. Any other comments/improvements? Thanks Simon FR.zip

I'm developing an inventory database. I have the following tables: Room - contains fields for buildings, Room #s, and a unique room ID for each room PC - contains PC info Monitor - contains monitor info Printer - contains printer info In my PC database, I'm trying to enter a building and room# and have it populate the room ID based on the room database. Can sopmeone help me do this? I've created room ID in the PC database and linked it to the room ID in the room database. When I enter a building it populates the room and room ID with the first record of the room database and does not change the room ID when I change the Room.......hopefully that makes so…

Vs. 6, XP - I need to find each unique product a customer has purchased and list the last date they purchased it. I need this unique product list in a portal displaying in my Customer file. I have a 300,000-record lineitem file. I originally thought self join CustomerID & ProductID as both keys then calculation (number) with: Case(Max(selfjoin::Date) = Date, 1)). I've used something similar for other things. Then find on the 1, then loop Set Field [Last, 1] then the 1 would be the right key for Customers constant 1 (because the Max calc couldn't be used for the right). I'm considering another idea and please see if it's viable ... Do the above only once …

Hi guys, Developer Version 6 This is kinda hard to put into words so bare with me!! I'm feeling rather muddled! I have several separate databases for each individual client. (lets call them client1, client2 & client3). The common fields that they all have are fileno, claimant and client I would now like to create an "appointment" database which, upon typing in the fileno in a new record will display the claimant and client from the client1/2 or 3. What will then happen is in the respective client database, that appointment record will display in a portal. The problem I am having getting around is how to make it so the new record picks up t…

I wonder if someone can point me in the right direction. I am having a lot of problems understanding the relationship model in 7. I have bought the books read the articles but am still having a fundamental problem. If I have three tables A, B, & C where B & C are linked with a simple relationship link. The record that is current in A determines the set of records in B & C (they only relate to that one record) What is the best way to achieve this is there a template that has this relationship? Any info gladly appreciated

I have created two group of related databases. One of Product information with "ProductID# tags", and another group of WIP (Work In Progress) with "WIP tags". I am trying to bring out information from the Product Information, but it just give me blanks with no information at all on all my fields related to that file. All help and opinion would be greatly appreciated. ***ps. Hope this question is not too confusing.

I have developed a fairly straightforward work order database for our company's maintenance department. Work Orders have a Time Spent field and a Time Estimated to Complete field ... these feed into a Percent complete calculation field. Useful for our management structure, etc. I've created a second Time Sheet database to log time spent on work order codes. Time is recorded on paper; at the end of the day it is input into the database. 1 Record = 1 Day's times. How do I add up the total time for the day, and add it to the existing time already recorded in the Work Order database? ie. something like Sum(Exisiting+New) . Here's my problem. Different day's tim…

Hi, after exploring FMD 7 for almost a month, i decided that it's time for me to get started with the development work. Just 30 minutes into the development work, i faced my first 'obstacle' which made me spend almost the whole day racking my brains trying to think of another way to work things out. I gave up.. hoping to see some light of guidance from the pool of experts here... I have 8 tables here namely employee, leave, dept, sub dept, leave type, manager, public holidays and a global table used to store all the neccessary global attributes. I have attached a copy of my DB design n an example of one of my layout. From the design, u can see that both the…

I'm having an issue with my DB since importing 3000+ records from our previous DB. When working with about 300 records previously, this didn't happen and I think the larger number of records now has amplified a previous issue. I am using a portal to show all license keys issued to customers. A couple of the portal fields are calculation fields that show graphical checkboxes instead of the boring FM default checkbox. When I click to the layout that holds this portal, FM pauses for a while and the 'Sorting Records...' dialog appears. It takes about 5 seconds to populate each line in the portal. The files are linked by the CompanyID, so I don't think its the rela…

Just begining to play with FM 7, converting a solution with 45 tables, and hundreds of fields and relationships. It seems that the relationship graph could get very big, very cluttered, very fast. Has anyone thought about any conventions for setting up the table and for naming the relationships so that it is easy to work with as it grows? For example, I'm trying to think of a way to name table instances so that I can quickly tell what's being referred to. Something like BaseTable~RelationshipDescriptor So I'd know that "People~Workplace::Phone" is the phone number of the workplace of a given person. I'd love to hear what others are thinking befo…

a system of users -< registration_join >- account >- manager there is a selection portal on the users layout that shows all of the accounts and when a user clicks on a row, the account is added to the join file and the user is allowed to use that account. The objective is to have two type-ahead filters for the portal: one where a partial account number is entered, another where a partial manager name is entered. I have attached three files 1. A normalized file where the manager name is not in the accounts file. This is slow but normalized 2. A non-normalized file where the multikeys are both in the accounts file. This is fast, but importing is…

I have used FM for years as a simple storage solution but suddenly I have to deal with relationships and after two days of trying and reading I am nowhere. Here is what I need to do: I have a database containing about 300 different wines. Each different type of wine has a unique number, the "wine number" and a certain inventory. I am trying to put together a catalog in a separate table, that shows some of these wines. Where it get tricky, is that my boss wants to sell some of these wines bundled, - meaning he wants to offer something like a case of three. How do I set these tables up to where I can maintain an inventory count? Do I A. …

I am having trouble understanding how the not equal relationship works. Consider two tables with a many to many relationship, say Group and Individual. I have linked these two tables using a third table (called GroupIndiv) consisting of two fields: GroupID and IndividualID. On a layout attached to GroupID, I have two portals. In one portal, I want to show the individuals that are part of the current group. In the other portal I want to show the individuals that are not part of the current group. I

Will relationships between globals work in find mode in FM 7?

I am using FM Pro 5.5. Here

I have created an FMPro 7 database that replicates the structure of an SQL database used for the online registration of individuals and projects for a science fair. A Users table captures info on individuals (including students, adults, judges, etc.), each with a unique ID and record. Another table captures project info - each with a unique ID. These two are linked through a table (UserRoles) that associates each UserID with one or more RoleIDs and a separate ProjectMembers table that connects one or two MemberIDs to a ProjectID (Projects can be entered by one or two students). In summary the key relationships are: Users.ID -> UserRoles.UserID UserRoles.ID ->…

Question: I have a database with two tables (an inventory of items and a work system). In my inventory I have serial numbers and inventory tags. I want to be able to look up items from my inventory using either of the 2 fields. Currently if I relate both fields it requires that I input both pieces of info to look up the details of the item in my work system. I want to be able to use either number to look up the details from my inventory. Is there any way to do this? I keep looking for an "or" relation option but I have yet to find it. Any help will be greatlky appreciated.

(Current environment is iMac runnig 10.2.8) In FM5 I used relationships between a new entry global field and text fields as dupchecks: "DupcheckName" gName to NameField within the same file. The subscript before using setfields to copy data from the global fields to text fields in a new record field was: Go related record "DupcheckName", show only related records If Status(found count) >0 {(get(found count) in FM7)} Dialogue: "this is a duplicate entry" Halt script. End if In FM7, this does not seem to work. I used the commit records step previ…

I have two relational databases. One is for inventory and the other contains customers informations. The Customers one gives a serial ID to the customer which is used in the Inventory database for reservation purpose. When I enter the Customer ID in the field CODE of an item, this item is reserved to the name related to the Customer ID. All that process works fine. What I need to do, is to see the items the customer reserved in the Customer database. With relationships, I can manage to see the first record of the Inventory database that has been reserved for the current customer. But how can I manage to see the other ones? I guess it would be a scripted thing …

Someone please help! I

Hi! I'm new to this board... I looked everywhere, but I can't seem to find the answer to my problem. I'm working on my first FileMaker 7 project. It's got 12 tables already. My main table keeps appointments that need to go through 4 steps of approval, and I need to keep track of who changed a record's status fields and when. FM7 will only remember a record's creation/modification dates, not a single field's, so I created 4 tables (one for each step of approval). Each table is linked to the main one through a sequential number field and has fields for the status parameter, modification date & user. I finally created a calculation field in the main table, usi…

How can i show the related records in treeview same as "Folder Explorer Bar" in "Windows Explorer" (e.g t1 have a relation with t2 by f1, t2 with t3 by f2, t3 with t4 by f3 and ... now i want make a tree view for show and create tn and fn with no limitation in n same as creating subfolders in folders and top level subfolders).

I have 4 files: article bills adresses positions I create a bill in "bills" with the help of a portal of the positions to define the articles and prices. Now I want to print the bill with a layout created in the "positions" file. With what kind of script can I get only the positions of the newly created bill? (Without a script I simple search for the number of the bill in the position file.)

Hi, Hi I need to print some labels from information in my main table, database. I thought one idea would be to auto copy some fields when entered in table 1 to relating fields in table 2. Is this the best way? The labes need to be a specific size and I only want a few fields from the main entries. I hope this makes sense, Badly need help as it is for work. P.s - I am fairly new so please be indepth. Thanks very much, really appreciated.

I need some advice on the best way to lay out the fields and tables for a unusual database I'm designing. I posted this to the fields forum, but was suggested to post it here and would get better results. I've decided to make a database for my cousins and a game they play called "Heroclix". I looked around and couldn't see any ready-made FM file for it, so I decided to use that to learn a few things about FM. This database would contain the figure's stats and would have at least one table for the figure data itself, plus another for teams and another for power definitions. All these are values taken from the figure itself and not necessarily calculated. …

HI, in a shared file, I want to limit records seen to those created by the user. I think I can do this via a portal but wanted to do it via "view as list". Is this possible?. The problem with the portal is it is not easily sorted by the user and is an all or nothing view.

In FM 5 I used relationships between a gMultiuse global field to Category text field in the same file to show a desired category: Set field gMultiuse, "ABC" go to rela. XX, show only related records. This worked great in FM5. When converted to FM7 there was the word "external" in the script def. The script worked well until I clicked into the go to related record script step. This erased the "external" from the definition and the dimmed external button will not allow me to redefine this. Why could the conversion define external and I cannot? What does external mean? Where did the "intuitive" in FileMaker go? Thanks all for any contributions…

Hello everyone... Here we go.. The setup: I have two tables called "Policies" and "Brokers" In the policy table I have a drop down field that list all of the brokers in the Broker table... Now I have a report that I have made that puts on the correct broker with there address from the associated table. all of this works... My problem comes from when I have another field on the policies table called Co-brokers...This also has a list; listing all of the same brokers from the same table as the first. On the same report that I did above...I try to get it to list the correct address with the cobroker that I have selected but all it lists i…

I am trying to recall a specific data from a different file/layout/field. The closest I got was to make a script using Open[Database#1] from my database#2. But all it does is open that file, and not the actual field( I have to browse through the whole database to find what I want). Please, any comment or help would be greatly appreciated. Thank YOu....

I am redesigning a v6 system in v7. One of the nice things about v7 is how much easier they made it to separate the front-end from the back-end. So this is what I want to do. The reason I need to do this system this way is that we are unable to make changes to the live system as it is a validated, FDA compliant system. Whenever we do a change to the system we have to go through change control. The code changes have to be made on a backup of the files, then, when the changes are tested and approved, we have to migrate the production data into the new files then prove that all the data migrated correctly. It is a royal pain in the you know what. So I said all that…

Greetings all. I've been poking around the forums for a while, and haven't seen anything like this. I'm new to Filemaker, hope this isn't a dumb question. Let me know if this has been talked about elsewhere here. I'm building a simple call tracking database, to keep track of the phone calls our customer service folks receive. So far it's set up with a database of customer info (name, address, phone, etc) a database of call activity (name, phone#, product used, problem, resolution, etc.) and a product database. The relationship between activity and customer is done through phone#. If the entered phone number is in the customer database, the relationship fill…

For years I have been trying to create a FileMaker database that could handle rental inventory. Specifically, I'm looking to handle orders for a special event lighting company that rents lighting equipment, and then checks the equipment back in. A user would input a Rental Begin Date and a Rental End Date. They would proceed to enter line items (lighting equipment) to fulfill the order. A user would need to have a "Conflicts" button that could run a script that would check for any potential conflicts with the order (e.g. does another sales rep have any of the same equipment already reserved or out on another order) Conflicts could occur via Rental Begin Dates OR Ren…

hi have a db i am desiging to track operations performed on patients, the patient side of db and procedures are joined togther i am having trouble creating records in the join table using value lists from the operation db have a look at the attached db schema - any tips please? cheers rick

Ok, this sounds easy so what am I doing wrong? I have a DB (Sponsors.fp5) that is populated with Names & Addresses. I am creating a DB of Donors who may or may not be in the sponsor DB. I have a Master DB that pulls from the sponsor db and populates the donor db (through a portal) with the people who donated. I have been able to use the Sponsor database as a list box to pull up names and lookup all the rest of thier info (Address kinda stuff). Some donors are not in the Sponsor DB. So, I want to take the newly entered sponsors into the Donor DB for future use. How do I add a record from the Donor DB to the sponsor database and set all the appropriate field…

This must be a common experience: What used to be a table (say, an attendance table, students x dates) acquires a new dimension, as I realize that what used to be a field (yes/no) comes to acquire its own matrix of data (attendance? excuse? participation level? comment?). Another example is: gradebooks used to settle for one box in which to record a score per student per assignment, but of course now I have a veritable world of parameters I like to record about every assignment submission. Once I've become convinced, I regularly plump for making a new "join" table... With FM7, I can achieve a quasi-tabular look still (say, students as rows, date-by-date across)…

Hi all, sorry to be a bother but I am afraid I have run into a bit of a snag. Here is my problem. In my database, I have a set of invoices each with due dates on them. For each of those due dates, the invoice will be one of three obvious choices: 1) It has been paid (whether on time or not is not important) 2) It has not been paid yet but is at present not late 3) It has not been paid and is now late, by some amount of time. I also have a field which calculates from there if they are option 3 exactly how late they. However, to do this was rather difficult. Many entries are made under one invoice number (invoice #s are not unique, they have many calc…

Here is the setup: I have two data bases we will call one main and the another customer. I have a portal in the main database that shows all customers relating to a field that I have. This works great. I would like to be able to click on a Customers Name (in the portal) and have a script or something open the customers database and go to the realted customer that I have clicked on. Tha reason I have to do this is the portal would have to be so large to show all of the information I want to see...So I thought That I could do this to bring up more information. Can anyone help...

I have a client who has thrown me a curve ball... Simple request... a posting at the bottom of his monthly invoice to his lawn care clients with 0~30, 30~60 and 90+ summaries for overdue accounts... not so simple! because he only wants to bring up the current month's invoices, not all unpaid invoices... I gave him the standard: script to find and print current invoices, script to find and sort all past due invoices and print individually by sub-summary aggregate... Am I missing something?

Hello everyone.... I have just recently upgraded to FM7 from FM6...so I hope all of my terms are right... In FM6 I had a field on a form (Now Tables) called Escrow Agent... When you click on this field it brought up all of the escrow agents for me to choose from... When I selected an agent that I wanted it automatically filled in the other fields with its information. Like address, state, zip etc... Now I am in FM7...I have tried to do this again...I have made a relationship between my main table (RecordID) and my Escrow table (EscrowID). Then I made a pop-up list just like I did in FM6...and that works...its shows all of the escrow agents in the escrow ag…

Hello, I'm sure this has probably been answered, but I haven't found the answer I was looking for. I need to create a database with students and courses. I would like to have it so that when I enter a student year and semester, the appropriate courses show up in browse mode. Am I doing something wrong? Example ======= Let's say I have Jack and Jill. Jack is in year 1, semester 1. Jill is in year 1, semester 2. Both can take 5 courses. How do I setup the relations table so that the proper information is displayed? What I would like is something that looked like this... Name: Jack Year: 1 Semester: 1 Course1: English Course2: Biolog…

Okay, so there is the pb : I have to assign "Products" to "Catalogs" (the number of catalogs is variable) and to "Pages" in these "Catalogs" ex : let's say that ProductId1 must be in Page2 of the Catalog2, in Page2 of Catalog3,..., in PageX of catalogX. I've tried with 3 tables, one for products, one for catalog and one for pages, i'm not sure this is the good way because nothing works as i was expecting.

I have mined these forums anonymously for a treasure of help so far in overcoming many obstacles in learning FMP and I wish to start my first ever post by thanking everyone very much for all the help given. But I am now stumped and can't seem to find the solution. My problem: I have 3 databases of line items (Expenses, Time Entries, Auto Logs) where different reps import their data from Palm Pilots. I need to create a Invoice DB from which to print a single invoice that brings in line items from all 3, and sorts using either Date, Client Code, or Project Code (common fields that exist in every DB) or a combination thereof. I have been successful at creatin…

I am having a problem with a multi-criteria relationship I am trying to create from Table A to Table AB (Join Table to :. I'll try to explain it clearly. Table A contains the list of Products Table B contains the list of Reps. One rep can represent many products, thus Table AB joins the Reps (: to the Companies (A)....a standard join. The only two 'input' fields are 1) a field with the Table A Primary ID and 2) a field with Table B primary ID. Every other field is a calculation field that grabs info from Table B through the Table AB - Table B relationship. OK. Here is my problem. I want to create a multi-criteria relationship between Table A and Tabl…

Some complex databases have as many as 10 files related to the primary file. These open as "Hidden" in both Mac and Windows. When closing FM Pro in Windows, however, there is an ugly flurry of opening all the hidden files before closing them. Doesn't seem to happen on the Mac. Likewise there are some funny transitions (color-inverted images) when using a graphic as a button. Any ideas for preventing these? Note: This is concerns the local machine, not the web.

I have a master file (MAccts) with an owner field with 3 values, an Accounts (Accounts) file containing user accounts. Among others, the Accts file has the MAcctNum, AcctNum, Owner field and a Type field. One relationship is based on a master account number (MAcctNum) present in both DBs. When I display a portal on a layout in the MAccts file, all the related accounts to the MAcct show up fine. Now, I want to display subsets of the accounts, based on the category of the account and its owner, on a single layout. I am putting multiple portals on the layout in MAccts and trying to set up separate relationships between MAccts calculated fields and Accounts based on …

Background: Very new to file maker 6 Problem: i can not get my relationships to work. I referenced 3 different books and i have followed the instructions step by step( and all three are the same) and yet i still can't access any information from the secondary file. I have set up the proper relationship, specified the fields, and when i type in a search to find multiple fields i get nothing. Is there some little step that I am missing??? If anyone can help, by all means. Thank you!

Hi, I have two related databases, DB A and B with the relationship rlA_AND_B. DB A contains a field with 6 repetitions (Field A6), which is related to a Field B in DB B, this latter is not a repeating field. How can I refer in a calculation in DB A to the related data of Field B DB B, which appears in the repetitions 2-6 of Field A6? In other words, What is the substitute for rlA_AND_B::Field B when I mean the related data in DB B of repetitions 2-6 of Field A6? The problem is quite simple, but I cannot figure out any solution for it. Thanks. csb.

I need help with an idea. I have a barcode feild that has an increment of 1 for each record. I then have this file with many relationships to a folder of files each with this unique barcode number. How can I make the barcode number act as a button and open the corisponding file with the barcode number ?

Educational database - I have created files. One of student information; one of a list of colleges; one of student SAT results. I need to set up a relational database which allows me to record what colleges each high school student applied to and the result of that application (accepted, denied, deferred). What would be the relationship of students to colleges - would it be many to many since one student can apply to many colleges; and one college can have many student applications....can anyone help? thanks. FileMaker Version: 6 Platform: Windows 2000

Hi, I'm trying to make a script that moves a record from one file to another. Records older than two weeks in File A will be moved to File B and deleted from A. I've tried to do this by making the two related by "record number", and then setting the various fields in File B. However, the delete script steps takes the record out of both files. This seems strange as I believe have the relationship set up so that related records are not deleted through the master, and can only be created one way. The FM Help says to use the Exit Record script step to make sure related records aren't deleted, but I don't think this step exists? Can anyone help point out what I'm d…

Sorry to ask such a basic question, but I just can't figure this out from the user's manual and a lot of experimentation. I have one file which is a roster of students at our summer workshop. It tallies up the total amount of tuition paid. I have a second file which keeps track of the budget -- expenses, income, etc. How do I link these two files so that total tuition (calculated in file 1) shows up in file 2? Thanks very much. George Johnson

With filemaker 6 I had a calendar file and a dates file. The calendar file had a script for a button that simply took you to the related date in the date file when you clicked on that date in the calendar file, using the go to related record statement. Since they were two different files they were two different windows and that was perfect as viewing both at once is prefered. With filemaker 7 I have put the date and calendar files together as two seperate tables in one file. To get it to act as it did I have added "new window" commands to get to the calendar. But now I'm having trouble getting the button in the calendar to go to the related record in the dates table,…

Hi ! Sorry for my bad English Lets say we have 3 tables A, B, C Table A has 10 Global fields (Gkey1, Gkey2, Gkey3 e.t.c) Table B also has 10 Global fields (Gkey1, Gkey2, Gkey3 e.t.c) Table C also has 10 Global fields (Gkey1, Gkey2, Gkey3 e.t.c) The Global Fields in every case is Keys to get images from a FMPro photo album I manage the Global fields from the Table A . I put the data in the Key fields via script and the images come via a portal. Everything work perfect. The purpose here is when I fill with data the Table A (Gkey1, Gkey2, Gkey3 e.t.c) Keys the corresponded fields (Gkey1, Gkey2, Gkey3 e.t.c) Keys from Table B & from Table…

Some of you may have been following my other thread but since it wandered away from being relevant to the define fields forum, I decided to start a continuation thread here. So... Here is my first draft, it is not pretty, but it should show the direction I think I am trying to head. I have some questions but I will first post what I have so that others may look at it before I ask my questions. Again thanks to all that have helped me get this far. contractMgt.zip

There has got to be a simple way - that I have overlooked or missed - that allows one to create a record in a related db from the master db ... I have a (master) NAME db that is related to a GATHERING db. The NAME db has all the names in our mail list along with addresses, phone numbers & the like. The GATHERING db has data for each of our annual Gatherings for each member of the NAME db. The NAME db includes an ID field unique for each record and the GATHERING db has a Name ID field which is related to the NAME db's ID field to create the relationship. We mail registration forms to members of our organization (not all members of the mail list are organizat…

Hey...Everyone.. Here is the situation... I have two files (Data Bases) one has insured information in it (like name, address, broker) and the other file has Policy Information in it (like Policy number, amount, Insurance company etc...) I need to make a portal on the first data base that shows all of the policies relating to that insured...Only that Insured... But wait... I also need a add policy script so I can add a new policy to only that insured...Please Help

I have a relationship that I keep checking. I have a field with a serial number called "Controlnumber" in a table called "REgistration" and I have a table called "A" and there is a field in there called "ControlA" . I set up a relationship between the two tables "A" and "Registration" and then I assign the look ups of three other fields in table "A" based on that relationship., Check everything and keep trying and it just doesn't work. any help appreciated. I think this relationship thing in 7 is difficult and maybe buggy.

Hi everyone... I have 2 data bases: Main data base -- contains all reports and other information 2nd data base -- contains broker data, which the main report uses to look up broker companies.. I need to be able to print a report (Using the Main Page Report) but using the information on the 2nd data base. Example: Main Date Base: I have a letter that contains company name, company address....Dear Mr. Contact last Name... 2nd Data Base: Broker Data Base Contains: Company Name, Company address, Contact Name etc.... Help

Hi All, I have a simple question which i still don't get it. I have several duplicate records and single record but what i want is to show only one time . I used self-relationship and status(recordnumber) but it does not work. let's say i have file and name: dd123 Bill dd124 Goerge dd123 Bill what i want to see is ... dd123 Bill dd124 goerge is there a way to do so ...i know someone has a trick on it . But i use recordnumber but it gives many dupolicate of 1 and 2 and so on. That is why it does not work. Can portal show only one time? Someone can help. I really appreciate it. Thanks Anh Tran

Hi Guys I have what is hopefully a simple question. I have two databases, an enquiry database and a client database. When an enquirer becomes a client I want to copy all the information I have on them from the enquiry database to the client database without having to copy and paste each field as I am currently doing. Ideally it would be great to click one button in the enquiry database that creates a new record in the client database and copies all the info over, or, alternatively, the button is in the client database and when clicked will import the info from the enquiry database. Any suggestions would be greatly received.

I can't figure out why I can't color my relationships. I select a TO and click the color wheel but it doesn't change color. I haven't tried printing my relationship graph yet - does the color only work when it's printed? I would love to be able to segregate my TOGs according to color while viewing it. Searching help on 'relationship color' brings up nothing other than to do what I am currently doing. I must be doing something wrong. Linda FileMaker Version: Dev 7 Platform: Windows XP

Hello If I have a field that is already a lookup , can it also be used to trigger another lookup. Lets say we have a record with the following fields Fruit, colors, Item number with a relationship we can trigger the look up of colors when the proper fruit is entered and it puts up the item number. But is there anyway to be able to ALSO input the item number and get the same fields answered with another lookup. Thanks

Hello I have a database with a few tables. I drew a relationship between the two tables in the graph window to the fields that could have a match. In the second database there are lots of possible words to match in its field. But when I do a find for the match word , I get an instant answer. In define fields , I do a lookup based on that relationship and it never works. Is there anything I can do. Any suggestions. Thanks