Relationships

I need to summarize how many hours a worker worked in one day. Workers are scheduled in a table called Schedule Line Items, which consists of Job Tickets (another table) for the Day. Worker Name and Total Hours are chosen via pop-up in a repeating field in the Schedule Line Items table. One worker may work several jobs during the day, and could appear in any repeat of the Worker Name field, with an associated total hrs worked on that job. How can I summerize how many hours one worker worked in a day?

Ok, stupid newbie question (and I'm just not "getting it" reading the manuals or FM's knowledge base). Thanks in advance to those who help. I have two tables (Table A; "Customer Data" and Table B; "Product Desired"). Table A is the table users will use to enter in their data. Every record in Table A needs to have a one to one relationship with a record in Table B (and only one). Up until now I've give every record in Table B a unique serial number (Serial Number Field) that was related to a drop down menu field in Table A where the user could select one option and marry the table records. Works fine. HOWEVER, I want to significantly increase the options in …

I'm having some trouble setting up the relationships between a few tables, getting a message that there cannot be more than one relational path between two tables in the graph (and Filemaker then wants to add a new Occurence to handle it). I'm more familiar with setting up data models using SQL than I am with Filemaker, and I suspect that my design may be fine for SQL but not Filemaker. So I'm hoping to receive some advice about what to do in this situation. There are Students, Teachers, and Courses. A Course can have multiple Students, and multiple Teachers. This is all pretty straightforward. The complication is that in my situation, the same person could be both a…

ok, this is not really a question (more like a wish or a rant) Shouldn't there be a "force to equal nothing" operator in the edit relationships window ? For instance there is a table that has three serialID fields (A,B,C). Field 'A' is always full, but fields 'B' and 'C' have a number in a mutually exclusive way (Either one is full or the other). Something like this: A, B, C 2, 5, 2, 6, 2, 7, 2, , 9 When I have a relationship to field 'A', I want to make sure I get only the records that have a blank field 'C'... and I would like to use an equal operator, otherwise we can no longer jump to related records from portals and stuff (inequalities…

I've got one table called Products and another table called Scans. These tables are related by a field called ItemNumber. As such, when I look at an item's information in my Products layout I can see all of the related Scan records associated with that item. This is good so far. There is a field in Scans called StatusCalc that is an unstored calculation and ends up with one of the following text values: Post, Posted, Sold, Oversold, RMA, Tech, Stock. So back in my Products layout I have my list of Scan records and I have to sort through all of the Sold stuff mixed in with all the stuff I still have in stock. I'd like to separate these out into 2 separate…

I have generated a website with the php site assistant and all works pretty well except the find page. The find choice is made with a radio button choice from a value list within fmpro. The not equals choice actually finds a list of records where the field is equal equal. I looked at the find.php and not equals is 'neq' I looked at the fmview.php and it converts 'neq' to '!=' This seems right. The greater than choice works as far as it finds a list of records where the text field contains data that is alpha greater than the data I am trying to exclude. I have noticed that you can't do a find in fmpro like 'not equals' or <> sampl…

I'll try and give the info you need to know without getting too detailed with all this. I have a tabled called Products. I also have a table called Scans which is related to Products by ItemNumber. These tables are actually located in 2 different FM files. I have a Products layout that includes a Portal listing the related Scan records. Again, Scans is related by ItemNumber so it lists all scan records with the same ItemNumber as the current Product record, just as expected. Now, I need to make another table occurance of Scans related by ItemNumber and 1 other field also. So the first thing I did was create a new table occurance called ScansInStock. I …

This should be simple but I can't find it: this is what I want: if the value of a field in a portal row (eg. project) is the same as in the previous portalrow then don't display it (using conditional format). Ok how do I grab the previous value? Pref. without adding fields and stuff, just want to solve it in cond. form.

I have gained some ground as to organizing my table structure but I am having a few issues. I feel as if I am so close but missing some small detail. Portal Lists: I have set up a table called "Jobs" to keep track of photographic work. Under a tab labeled Contacts I want to have a portal list, similar to the Events Management template, which will allow me to attach various people to the job. When I click the button to make a new contact I am sent to the Contact Layout and I am able to fill in the information but when I go back to the Job Layout the information is not there. I do see an additional portal row but no information in it. Second Portal List: Und…

Hey everyone, I have a lot of background with MSSQL and I am missing something that should be fairly basic with regards to table relationships. Using the below picture as reference is there no way to do the following? FEE::LoanOfficer_Branch = fee_emp_vl_LoanOfficer::Job Title OR FEE::BranchMananger = fee_emp_vl_LoanOfficer::Job Title AND Branch = Branch

Without backing up my database I started to erase some orphaned relational data. In the process I seem to have messed up the main database as all fields now show 'Table missing'. What have I done and how can I recover my records? I can't seem to export anything as I might recover in that way I suppose.

FM 8.5. I have two tables, A and B. Table B is a simple list of names. I want to be able to choose names from the list to insert in records in table A. There is no relationship between the tables. Is there a way to do this?

I have an invoice table and a bin table. The bin table have 700 records from 1001 - 1700. What I need is when I create a new invoice, FM would automatically assign the next available bin number to that invoice. And that bin number won't be available to any invoice until that invoice has been cleared. The logic sounds simple but I'm not sure how to do it in FM. Thanks.

Hi, I've got this database almost working, but I'm having trouble getting it to print the line items (in a portal) related to an individual estimate. I've tried many things to figure this out and no luck. Could someone open my file and try fixing it so that it will print what I need? Thanks so much! Estimates_Copy.fp7.zip

This might have been answered elsewhere, but I couldn't find it. If so, feel free to link to elsewhere, I'm sure there's a common (if not simple) solution. I have an employee table, with an ID number, a username and a full name. I also have a Job table, which has a Employee ID as a linking field, so where Job::Employee ID = Employee::ID. The employee can create a Job, and I want them to be able to enter their username OR their ID number into the dialog. If they enter ID number, it's easy. If they enter username, ideally I'd search the Employee table for that username, get the ID number, and paste that into Job::Employee ID. However, I the employ…

I am trying to figure out how to auto-enter a date that's a week later than the previous record & found this to use as an example: http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000333 I don't understand the relationship in the file, though. There is only 1 table; how was the "Previous Record" table created? Also, what is the difference between --< and >--< thanks!

I have a database that tracks music, specifically records. Assume I have a date in Column A for pop music and a date in Column B for R&B records. Some records may have a date in both columns, some only in one column. Is there a way to do a "merged" sort so the dates in Column A & B would be sorted in sequential order whether the date is in Column A or B, or both.

[color:red]Click each link below each picture to see picture better. See pictures below to understand file structure that I've built that works but is going to be terrible to replicate in mass, and doesn't really address my needs. I've achieved one goal - to see all locations on one layout and all the pallets that are in each location. http://www.furniture-partner.com/picture0.jpg http://www.furniture-partner.com/picture1.jpg http://www.furniture-partner.com/picture2.jpg To enter the data, the user creates a new pallet number and then the location is chosen based on what space the forklift driver decides to put the pallet. See here: …

I am creating a database for a photography business and I wanted to know If I am going in the wrong direction before I get to deep. I need to keep track of each job and client along with the contacts that relate to them. I have a table called "jobs" and one called "contacts" In the contacts table I have a "ClientYesNo" field to keep track if this particular contact is a client and I want to have a portal list showing any other contacts related to it. On my "Jobs" table I have a field to identify the client and also I want to add a portal list showing contacts related to the job. In my previous files I had "Jobs" "Clients" "Contacts" but figured that the "clien…

I'm looking for some advice. Currently I have to work with 2 FM files. One is hosted on FMServer and FM Clients connect to it on our internal network. There is a 2nd file that is hosted on FMServer Advanced using instant web publishing that is available to the world. The second file is for people to fill out a questionnaire. I take that data from that file export it and import it into the first file. then remove the records from the 2nd file. This is for HIPAA (HIPPA) security reasons. Would it be possible to setup a file on the external/web server that can be hosted with IWP but all the data goes straight into my main file. Or would you Pros reco…

I'm in the process of making some modifications to the FileMaker Business Productivity solution to customize it to our use. I've got one section in the projects area where I would like to grab some data from the contacts section regarding the staffing of an event (phone number, shirt size). I've set up a relationship between the event staff table and the contacts table, but the data is not appearing. Am I at least on the right track here? -Matt

I building a testing solution using Filemaker. I have one table for questionText and another table for choices. Some questions are presented to the user with a hidden answer and in such cases, When the user clicks a show button, the answer is shown. Whereas some other questions appear as Multiple choice questions with 4-6 choices for the user to choose. Total number of choices vary from question to question. That one question might have only 3 choices and some other question might have upto 6 choices displayed. A set of choices make sense only in the context of a particular question only & Each choice on its own might not be repeated elsewhere. Like for …

I currently have a flat database which has been functioning fairly well for some time, but which we are beginning to outgrow. Keeping track of maintenance costs, user and computer allocations, and other matters is becoming a real chore. What I want to do is make this relational so that I don't have to enter redundant information, and so that eventually (once I've learned how) calculate total cost of ownership for fixed assets. I'm running into a problem where I seem to have multiple many-to-many relationships, and so I'm looking for some advice on how to modify my database to work as a relational one. The first many-to-many is that I have locations with multip…

I have a table with three fields "City" "County" "Postal" They contain every postal code in the state of Florida and the corresponding City and County. I figured that this be used by my other tables to auto complete the missing information. Like I could type in the postal and it would auto complete the city and county Or I could type in the City and it would auto complete the County. What would be the easiest way to make this work?

Hello all - had a look through the last few pages of this subsection and couldn't find anybody else with a similar problem. This relates somewhat to this thread. Let us imagine that we have a table called PROJECTS, uniquely identified by the Project Code. There are two other tables - EXPENSES and ALLOCATIONS. An Allocation represents a collection of similar expenses against a Project. eg, $400 is allocated to Fuel Costs. All Allocations MUST have a Project Code and a unique name. An Expense is an expense against a Project. This may relate to a previous allocation or it may not. In other words, if a new Expense was created and tagged as "Fuel Costs" it wou…

I have two different tables. T1 & T2. T1 has an indexing unique serial number (record Id). I have a field in T2 which i need to automatically index based on the T1 record ID so every record I create in T1 the records created in T2 will be sequential starting from 1 each time... not ussing the @@ command... I need it to be in a field... is this possible?

I am making an inventory database / work queue system. The work orders are entered by a user, schedualed by the help Desk and addressed by a Tech who resolves the Work order. These three people with three different privilege sets come together to create one complete work order record. Which is related back to the inventory item creating a growing history of service. The Idea of using one table for the work order only lets me use auto enter features and validations for the first person entering data, the rest of the fields cant use any auto enter (date based or user based) and I can check off the cant be empty box. I know I can script those into the other two users f…

Was looking at the database definition of the contact management template included with FM 8.5 and above. Could someone tell me why there are fields like "Scratch", Similars CompanyKey, Similars Multikey ans so on. What purpose do these fields serve? Thanks in advance for any pointers to any resources on the web or books explaining the design of built-in templates in filemaker.

Long-time reader, first-time poster … I’ve been struggling for days on this one: I have two main tables, CLIENTS and ORGS. A third table, RELATIONSHIPS, defines relations (memberships) between CLIENTS and ORGS. A fourth table, ADDRESSES, supplies contact info for all of the above. Seems straightforward. But, CLIENTS have their own addresses. So do ORGS. When a CLIENT becomes a member of an ORG, I need to display both the CLIENT addresses and the ORG addresses – from the CLIENTS layout. I’ve been able to accomplish this through a portal. So far, so good. The problem is when I try to tag one of the ADDRESSES as preferred and display this information in …

I'm a long-time user of FMP, but I'm trying to do something that's not working well for me. I've got a membership database with two primary files -- members and chapters, linked on a one-to-many relationship. I would now like to be able to show just the chapter officers in the chapter file, so that when I pull up the Dallas Chapter, it shows their officers down below. I tried using a portal, and have gotten the officers to show up, in rank order, in the portal, but below that are all the other members who are NOT officers. (This is complicated because chapters have different numbers of officers, depending on their own unique circumstances.) Ultimately, I wo…

In my head this seems easy... however once I sit down to make it work... I can't, then again, I'm a newbie! I have a Contact Management database that I have created. Recently I added the mail.it plugin. I now have two tables with very similar fields. Because both tables are referenced in quite alot of different scripts and layouts I want to avoid deleting one or the other, instead (I think) I want to create a relationship between the two. Both tables store contact info, but with different field names. They both have First Name, Last Name, Address, Email address etc. Both have a Client ID field which is where I think the relationship would be created. How do I auto…

Hi all....have been cracking my head to develop a excel pivot table like report for my food and beverage invoicing system. The key is i need a report which user can select start and end date and also whether drink or food so that they can view the summaried invoice lines transactions within the selected dates and by food or drink category. I'm wondering anyone can help other than using custom dialog to capture inputs and perform a script to that. thanks, Heman

I have two databases which I have linked with a serial #. I have some fields ( not same field name ) in each one and I am able to see the different fields from either one. However when I create the fields on the child it is marked as " Unrelated Table ". What is the problem ?

I want to have an option to view data in a form or in a table. The way I was thinking was I would create a self-join to the table in question, then put up a portal on a tab field; the tab is activated and the portal appears when the user clicks on the "view as table". I joined the tables using a field (lets call it "A") and I want to list all the values of "A" for all records in one portal on each record. My only question is how do I get the portal to show all the records from the table? I tried to make the portal and just put the fields in as connected to the parent table, but only one record shows up, instead of a list. Now that I'm thinking about i…

I am trying to create a database that will eventually be fairly involved, but being the newb that I am I barely know where to begin, so I thought I would start with the Easiest part and then once I learned what I was doing just a little, I would work my way to the parts that will be more complex. So here is the issue right now... I have my database with 2 tables right now, we will call them table_A and table_B In table_A I have 2 fields, Category and Category_ID: In table_B I have 2 fields, subCategory and subCategory_ID I am not sure how to make it so that when I display the records from table_A in a dropdown list, any one of those given records could…

I believe that I need a self join for what I want to accomplish but I am not sure on how to get it to work. Table has to fields: Stock Reorder Level I want to make a new layout and have a portal in that will display only the records where Stock is less then or equal to reorder level. How would I accomplish that? I tried a self join with Stock >= Reorder level and vice versa and it did not work. I also tried adding a id = id plus stock >= to reorder level and that did not work either. Any tips appreciated.

Hi, I'm a total newbie in need of help, here is what I'm hoping to achieve I have my main table with the following fields pet id supply1 supply2 foodlab pet loc Another table named reference with the following fields pet loc call number refer id How can i add(import or merge) the fields from the reference table to my main table based on the pet loc field. I tried making a relationship between the tables but that didn't seem to work. If in my reference table pet loc call number refer id ------------------------------------------------------ kennel xpi778 33349 house …

I sporadically get this error message "This record cannot be modified in this window because it is already being modified in a different window” even when neither of the users has that window open. It is interrupting a Script step. Any ideas? To explain the various relationships etc would take too long, so has anyone else experienced/solved this little dilemma? Or let me know what information you DO need to formulate an opinion. Thanks again! Martins

I have a many to many relationship between a "Clients" table, a join table "Matters", and another table "Cases". In my relationships table, there are two instances of "Cases", one is for active cases and the other is for inactive cases. There is a status field in the "Cases" table that is "yes" if the case is active and blank if the case is not. In the join table, I have a field that is set to the constant "yes". The two instances of the "Cases" table are linked to the join table through a multi-key relationship with ID number and a this status field. For the active cases, the status field needs to equal the "yes" field in the join table, and in the inactive cases, it nee…

Hey all, I'm using FM Pro 8.5 on WinXP. I'm making a training documentation database, and I've been having a bit of difficulty figuring out how to accomplish what I want. I have a database of users, documents and requirements. Users are assigned a GID (group ID) based on their department, the requirements database has 2 columns, GID and SOP (document). Each line is broken down like this: GID has a list of group IDs that have a certain document seperated by 2 colons as a requirement: Ex: MFG::FAC::IT The SOP field has the document number in question. My main question is how do I get FM to search for only partial selections in the GID (If user ID is…

NewBie, This is hard to explain however. I'm an Optometrist creating an invoicing and payment system. The problem is Frames have 1 item number in stock. Lenses have three item numbers. When it comes to creating an account I create a new record for each item number. I have created look up fields based on the stock number ( frames have one stock number and one item number this is easy, lenses have 1 stock number however three different item numbers to look up.) how do I create a new record for each of these item numbers. I have in the past scripted and simply did a set field type solution however the script was a mile long. I hope this is sort of understandable Thanks

HELP... I have 2 databases and they are linked with 4 relationships (A=A and B=B and C=C and D=D) If all 4 are filled in no problem it matches the records BUT if only 2 of the 4 relationships are filled in (other two are blank in both DBs) then it can't find the records?? How can I set it up to realize 2 are blank but they match and the records are looked up? Thanks

I am creating a database for tracking speakers at a lecture series. I also want to be able to send a letter to the speaker after the lecture is done. I have a table named Speaker Info that has the fields: Name, Lecture date, etc. I have a button on a layout that displays the speaker info fields to fire a script named "send final letter". I have a separate table named Letters that has a layout for the letter. The 2 tables are related by speaker name & date. I want the "send final letter" script to switch to the letter layout and drop in the speaker name & date but I can't seem to get this to work. Thanks for any help...

A beginner here. I'm not sure how to explain this and there is probably a simple answer that I have overlooked. I've tried to search for the answer using various key words, but to no avail. I have a table with multiple prices for the same item and I want to grab the appropriate result using a code entered elsewhere on the form. eg.: PriceCode Price1 Price2 Price3 176 50.00 60.00 70.00 On input form, before entering the PriceCode, one enters a PriceScale (say 1 to 3). So if the PriceScale is 2, then entering PriceCode 176 retrieves 60.00 A push in the right direction please??

I'm trying to create a database to keep track of a tennis league. I have a Players table and a Matches table and set them up as a many-to-many relationship. The trick is, at least for me, that there are more than one players. The db will keep track of singles as well as doubles matches. In the Matches table I would like to create a portal that will list all of the players (two if a singles match and four if a doubles). That seems fairly straight forward - I can just add those names to the join table. However - and this is where I'm stuck - only one of those names will be connected to the Players table (via _fk__Player_id). I don't think I am thinking about this…

Does anyone know what the maximum item limit is for a multi-key? In other words, how many keys can be stored in a multikey? Is there a limit to using a multi-key with the GTRR script step?

Hi, I'm total newbie, hopely this is right sub-forum. I have personnel type of database. There is "What other people in our organization current person knows"-field. User should be able to choose multiple people to list, which lists all other people (who are in same database) current person knows personally. Maybe using relationships and pop-up menu? In same database each person has pet name and i have second database about activities. User should be able to choose multiple pet names from pop-up menu in activities database, this way activity can show who participated to that activity. "Show repetitions 1 through 5" is sometimes dimmed??? Thanks

Hi all, I'm trying to come up with a way that I can lock the data in an Invoice, once it has been sent to the client, so that it can not be modified. I thought about archiving the data, but then I still need it to display in my portal so that I can see the Client's history. TIA for your help Kie

My bookkeepers have asked me to provide some monthly summary data from our homegrown order database system. I'm not exactly sure how to architect this. The report they want would summarize the Quantity, Gross and Net Revenue for each SKU we sell. Each row in what is essentially a spreadsheet represents one of our SKUs, then each column gives the Quantity, etc. Have a line item table that contains all line items for all sales. How do I set this up? I imagine I'm building Summary fields in either a new table or in a self-join to the Line Item table, but that infant thought is as far as I'm getting. -) I appreciate your advice.

I would like to know how to move records between tables in Filemaker Pro Advanced (version 8). I have one table called "Referred Students" and another called "Active Students" and I would like to create a script in Filemaker Pro to move the current record from "Referred Students" to "Active Students". Is that reasonable?

any help would be great,.. thanks,.. ! Using FMP 9 and FMS 9 over a T1 line moving a max of about 140KB/s I have 3 tables (and or) files - table 1 has 15,000 records with 100 fields (11-MB) - table 2 has 15,000 records with 8 container fields and a key that relate to table 1 (3-GB) - table 3 has 120,000 records with 15 fields that relate to table 1 (28-MB) table 2 holds up to four 6KB thumbnail images and up to four 40 KB images there is a scanning plugin that aquires the images into table two I have done extensive network throughput testing -- and have constructed various designs where, with no records, the total Bytes transfered from …

I would appreciate any suggestions regarding how to create a relationship between a calculated date field [Get(CurrentDate) + 60] to a corresponding date field in another table. I am interested in finding all records that have an expiration date that is effective 60 days from today. Does the calculated date field have to be formatted as a global field in order for the relationship to work? Thank you.

:( I know there has to be a simple, elegant solution for this, but I seem to have brain-lock. I have a simple database with three tables. The first and second table is related with a one-to-many relationship. I currently have an id created by using Auto-Enter Serial Number field options. Serial numbers work great unless you need to later work on a copy of the database to make changes and then import the data into the modified file. Obviously when you do the import a new set of serial numbers are generated - not good. What is the CORRECT method for generating serial numbers that won't recalculate/redefine with import into a duplicate database.

Here is my setup. I've got a many to many relationship between "Cases" and "Clients" through what I guess is a join table "Matters". Each Case has multiple Clients, and each Client has multiple Cases, but each Matter involves only one Client and one Case. Each matter stores the ID numbers of the Clients and Cases. Right now, to create another Matter and link a Case with a Client, on the Case layout I have a drop-down list of all the Client names taken from a value list, and a button that executes a script to make a new matter. My problem is getting the Client's ID number to complete the relationship. I'm sure there is something obvious that I'm missing, any help woul…

I'm having an issue of hiding the [color:green]Parent RecordID while in the [color:green]Child table using Pulldown menus to select the record. I attached a file with 2 examples ([color:red]test 1 and [color:red]test 2). [color:red]Test 1: Uses 2 fields in the pulldown, [color:blue]ID (The result of selection) & [color:blue]Company name (What you see when you pick). This looks good while selecting, but when leaving the field it just shows a record [color:blue]ID field for the company field which confuses the user, (even when I do a lookup of the related company name right next to it) [color:red]Test 2: Was an experiment, I used a calculated f…

hi, i'm having a major fm project on my hands (it seems) since i'm quite new to the software. the problem is complex, but i'll try to explain it as clearly as possible. my fm file is such a mess at the moment, that i prefer not to upload it. if needed, i will, of course. basically my client manufactures and sells design objects: rings, boxes etc. - there is one table for product types (example "square ring"), which includes general info, prices, designer, etc - another table is for the single products (ex. "square ring / size 17 / blue", square ring /size 18 / blue" ...) - there is one table for contacts - an order form was constructed using a order line item…

I'm trying to set up a system where I can type in a client name and their address from the client address/phone number database will pop up into an ordering service. I've already linked them, and did an "auto-fill" with the lookup to the former database, but nothing seems to work. Thank you for your help! - mL

Hi Guys You have all been really helpful with my previous posts and my job management system is working well but I have hit a massive sticking point and I hope you can help - or I'm in the s*&t!! I have done a series of finds and constrain finds to find a set of records for a particular customer for a particular month, with a value for invoicing etc. I now want to show all these jobs on one invoice and then total them up and add VAT etc. But I can't seem to get it to work and I'm not sure what relationship to setup? When I add a portal to the invoice layout it just shows one record. I have managed to set up the invoicing for other jobs and customer whe…

I've been driving myself crazy with this one. I keep getting close to what I need but its not quite right. I think it would be best if I describe what I'm trying to do. I have a questionnaire someone will fill out.As they fill it out it creates a contact record for them. In the process it asks for their parents information. As they input their parents contact info I want that to create contact records for one of both parents. I've gotten it where I can create one parent but not 2. I'm attaching a file that I've been working with so you can see what I've done. Any advice/tips are appreciated. family.zip

I have a photo library that I am looking to publish to the web via FWP. The db publish well except that there are certain Records that I do not wish to publish. I thought of adding a new field that indicates that the Record should not be published and then create a new table that publishes only the Records that do not have this 'flag'. Now the question is 2 fold. Is this is good thinking? How do I make it work?

Needing a formula or a join table, or? In an anchor-buoy table occurance scheme, I have job specs (some y/n, some multiple choice)in one table, service IDs and rates in another. (pt is to be able to change rates w/o changing formulas throughout). Got a nice calculation to relate job to svc ID. But I need a formula that says "if the svc ID from this job field matches this Svc ID in the rates table, use that rate." Getting a portal to do this has me flummoxed. Hints toward the right direction greatly appreciated!

Hi I'm new to filemaker and I am trying to link three databases 1- am membership database 2- a to do list 3- a budget database all off of one layout. The idea is I'd like to while inputing a member click on a link and see my to do list pop up or my calendar. These are the steps I've taken Manage-Databases-External Datasources-Add Then New layouts-Show records from- And I only have the main database, the to do list and manage database options Tried creating a brand new database (budget) and linking that, it didn't work either. Can't seem to get more than one extra external database to show up. Any ideas

Need some help with what I think is a relationship problem. I'm trying to get some data to display on a tab but can only get the first record to show. The attachment explains it a lot better. Many Thanks. Mick Test.zip

I have a link here to a screenshot of my relationships table Relationships Table. My question is this: We work with families and generally we enter the parents as our primary contacts, which fall under family_id . Then, we can enter their children and the various info for each child through a portal to the youthserial_fk link. Here is my problem. Every once in a while we have a youth whose parent is a primary contact, but who is also , as a youth, an independent client themselves - and I don't know how to create a relationship where both parent and youth can be seperate records under family_id, but then still allow access to the youth's information as a child …

When i'm doing a field lookup (I have two databases, and they are linked via partnumber, and the invoice number is looked up), it always gives me the oldest invoice number, even though I have multiple invoice numbers matching the part number. How can I make filemaker lookup the LAST matching record given instead of the first?

This may have been covered, I'm new to this forum. I want a record in File B to match to a record in File A if "07/2007" from B matches a record in File A whose start and end dates touch (begin, occur during, or end) in 07/2007. It occurs to me that you can match to a (dreaded!) repeating field, if only I could figure out how to populate that field with a month/year with one repetition value for each month. My guess is that there's a smarter way to handle this without resorting to a repeating field, but how do you match to a bunch of possibilities? In case this isn't clear enough, say a class starts on May 15th and ends on July 3rd. I need to pull a …

Hi all. I have a fairly large and complex database solution I have been building that crashed yesterday (no back up!!). I was able to recover it and all seemed well except that strange things are happening with the relationships. For example: I have two related tables "avg" and "fw" which are both subsets of my main table. "Mian". They both have the same criteria for the subset( ie field 1 = x). I have portals on tabs in a layout that access each of these related tables but only one will work at a time. In the realtionship window everything appears to be as it should ( I have over 150 related tables in this solution) but I can't figure out why this is happening…

I am stuck... I am creating a database to track rehearsals and performances for musical groups. I want to create a report for each musician with only his rehearsal and performance dates. The problem I am having is that one person can be in multiple groups. My relationship is based on the group they are in. I have assigned each person to groups. (Example, Red Team) My tables are: Musician Groups Rehearsals Performances I want to create the report using the sub summery feature.

Basically I have a DB of rooms. Each record has 1) name 2) area 3) generic type of room (eg large, small). I want to be able change the area so all similar generic types change. Hence I have a self relationship by generic type. This seems to work until I try to add the areas up as the relationship refers only to the first record. Is there some way around this? thanks

I have a shipping database where I want to be able to pull recipient address information from any of several different databases (different types of clients, etc.). Each of them has different types of keyfields, and I was hoping to have a single foreign-key recipient ID field in the shipping table to store whichever one was looked up, so it could be used in the client databases to display related shipments in a portal. I can imagine having 3-4 separate "picker" menus that pull the key into the same recipient ID field but use different value lists based on separate relationships. But for the address/city/state/zip fields in the shipment table that I want to populate w…

I want to redesign a pretty simple cross-reference db that we use here at work. Its a very simple flat file, one table beast at the moment. A little history will possible shed light on matters: We make crimping tools for use on electrical contacts that are used in a variety of connectors. There are over 1,000,000 contact part #'s worldwide - we have identified some 50k numbers, linking them to various tooling we manufacture. Our simple table has the connector company, part number, size, etc, and then the remaining columns, about 14, which are used to denote our tooling that works with this contact. For example, say we have contact 'A' - it could …

Can anyone solve a problem that I don't have the expertise to solve myself. I have a diary table and a to do table. They are related by a global in the diary and a user id field in the to do. At present any user can create or view each others to do's by setting the global to the user id. The problem is how can I create a "global to do" that is visible in everyones to do. Second problem is how can I create a "private" to do such that only the logged in user can see. That is that user can not see the other users private to do? Joseph

I have one table of contacts, with all of the same general fields like name, address, etc. There are about 12 different categories of people i work with, and each category of people has unique fields, but never more than 20. Should I create one table of contacts, fill it with all of the fields for the different categories, and then create one layout for each type of contact? meaning one layout per category? So I will have a generic contacts layout, and then add the category-specific fields to each duplicated layout? I know this is not using filemaker to it's full potential, since this way would just be a flat database, but this would work just fine for me, …

Thanks in Advance to all you Filemaker Gurus! This is a film rights db. I have an awesome portal setup with Territory & Film Type. WORKS GREAT! I need the Title field in Titles to be related to the Title field in avils, and Title:film_type needs to be the category filter instead of Avails::film_type..I can't make the relationship work and I've tried it every way! I hope someone can help me! Enjoy the lovely portal!

Help pretty please.... I am very new at Filemaker but very determined. I could really use some help with this stumbling block I am stuck on. I have three tables: AREA, BOOTH, INVOICES INVOICES are created by a booth by booth basis. each BOOTH is found in an AREA. I have two hurtles I have not been able to accomplish. 1.) insert daily totals by AREA in the header of my form 2.) view a list of all booths and there daily totals Helping me solve this would allow me to leave my computer for awhile. Any help or direction is most appreciated.

I have two related tables Timesheets and Tasks, where users enter time into the Task table via a portal on a layout based on the Timesheet table. The Timesheet table then has a field that concatenates all related tasks for a particular day&project&employee into one calculation (text) field using the ValueListItems function... this concatenated description is then (theoretically) what appears on our client invoices. I'm running into a problem looking up timesheet records where a field on the task record is a certain value. I have a scripted lookup to filter to all the correct task records, but how can I then switch to a Timesheet-based layout and look up all t…

Hi there! I have a contact db with a contact table and a related contactLog table. Now I wanted to duplicate a record as I had a new contact (Let's say: Mr. Smith) related to the same company with the same address as another one (let's say: Mr. Miller) I already had in files and changed only the name and phone number. Well, now I started to make entries in the log to Mr. Smith's data and afterwards I got the shock: The same Log entry I made for Mr. Smith was also added to the Log of Mr. Miller. How can I resolve that bug? I attach the relationship graph of the two tables in question. thanks hans Contact_Log.pdf

Hi all, I am very new to FileMaker, therefore, I would appreciate any help. This question may have been asked before, as I couldn't find similar solution, I thought perhaps I should raise the question instead of spending hours browsing the forum. Anyway, my problem is as follow: I have defined a table with records of students who have enrolled for one particular training course - called "Course". At the end of the enrollment period, these records will be archived, which I have created a table called "history" to capture all the records. However, I don't know what is the easiest way to archive the "Course" records to "History". Basically, the fields in "Course" and…

Hi, I have a field called status which is set up as a radio button with the options Current, Pending, and Parts. If I have 50 total records for example, I would like to know how many there are of each Current, Pending, and Parts. I have tried the Count function but it is just not coming to me. Any help is welcome Thanks, Dan

I am in the beginning of designing a fairly complex system for our business. We’re in the typical 3-ring circus of having a database for our clients, excel spreadsheets for our sales numbers, and then an accounting program to track invoices/receivables. I am trying to consolidate this process to one central database, and I plan on using the many-to-many model. In other words, invoices would be related to clients, and each invoice will have related line items, and then each sale/invoice will be summarized to it’s respective job (each sale is part of a unique job that we set goals/expecations, and monitor if it’s being exceeded or underperformed) My concern is th…

I am trying to add a layout called property listing to this database and either my relationships are wrong or I have got off to a wrong start with designing this database. I try to get a property listing that has all the properties and the name of tenant occupying along with phone numbers. I get either the property list and no tenant names or I get the same tenant living in all the properties. I have enclosed a copy of the database if someone could critic me and see if I have gone off base. Thanks Property_Tenant_System_Clone.zip

Hello, I am making a database that tracks companies started by alumni. I am trying to make an area for "related contacts" where the user can find other alumni that have the same values for certain field (ie. graduation year). I figured I could do this with a portal and giving each value that I want to use in the search criteria a unique serial number. My question is how do I create a field that will autogenerate a serial only if the value of a different field is unique? For example, if I wanted to find companies in the same city. Right now each company has a unique serial number that is linked to the whole company record. I would need some type of function for t…

Hi, I have a table of workers with contact info. Each worker is also associated with several keywords according to what they do. Should I make another table with workers and keywords? If so how should I lay it out? ie. should I have a Name field then Keyword1, Keyword2, etc? Or should I make a list of Keywords and put the names associated under each keyword? I want to have a page where people can search for a worker using various criteria such as keyword or city. FYI There are about 700 workers. Thanks in advance!

Deleted post

I am currently developing a new database for our mobile phone retail store and have hit a brick wall with one of the features I am trying to implement. I will try to keep this brief! this is what I have (that is relative to my problem) 1)Sales Invoice table (which holds customer orders) 2) Sales line item table (which holds the individual lines they have purchased.) The main layout shows a portal to the line items table and there is a relationship to link them via an Invoice_number field. - this works fine. There is also a second portal on the layout that shows all customer activity -for this I have created a relationship from sales_line_items to sales…

hi trying to adjust one of the basic filemaker example - the Business Tracker, which can be found here all i'm trying to do is add a new main button module "named" quotes, this is very confusing - hopefully someone can advise me on this.

Hi guys, I'm a new FM user and this is my problem: I have 10 fields Fibre1, Fibre2, ..., Fibre10 In each field is somthing like this: 20% cotton 70% elathane 10% mettalic fibre ... I need to put in fields F1, F2, ...F10 these values but from max to min: F1 = 70% elasthane F2 = 20% cotton F3 = 10% mettalic fibre Do you have any ideea? Please help. Thanks.

Here is my setup. I have one table of Clients, and another table for Cases. Each Client can have multiple Cases, and each Case can involve multiple Clients. In each Case record, there is a field with a list of the involved Clients separated by newlines. Basically, in each Client record, I want to be able to have a portal of all of the Cases that it is involved in. What would be the best way of doing this? Thanks, I'm kinda new at this. If I didn't explain something clearly just ask.

I apologise to anyone who has already tried to help me on this, but I am still tied in knots with what seems like a basic problem... ORDER table - one order ORDERED_ITEMS table - many items for one order [there is also a Product table with one record for every variation of model + color, each defined with a unique Product_Code] ORDERS has a form layout with a portal which should display the total of all related ORDERED_ITEMS summarised by model + color [ProductID]. Basically, if you have ordered 3 blue widgets and 1 yellow widget, that should appear as two rows in the portal. At the moment the summary field is working but I am getting 4 portal row…

FM 8.5. I have three tables: Logs, Miles, and Tax. Logs is related to Miles via record ID’s. I want to place a portal in Logs to only display records from Miles that are filtered by a criteria in Tax table. Is there a way to do this? For example, in the portal I want to show only those miles records that meet the criteria Flag = 1 in the related Tax table.

I need a workaround for GTRR. I begin in a layout showing courses in a portal. I click on a course button and execute a script which sets local variables for the Content Area ID and Course ID. I then go to a Course layout which shows objectives in a portal, find the selected course, find the rest of the courses in the content area of the course and although I have the desired subset of courses showing in the course portal and the selected course highlighted, I do not have the related objectives in the objectives portal. To get them I must click on the highlighted course which executes a script to find the related records. The problem is although I see the desire…

Okay i've just made some kind of horrible error. I make a relationship and now my database is seems to be stuck in an endless loop (Find in Progress - Processing Query). it starts automatically when i open the file so i'm hoping you all can help. Any suggestion on how I can get into the define DB area and break that relationship?

Hi! I have two types of "meetings" I am tracking: Faculty Meetings and Council Meetings. I have created Table:Meetings, and each record has field:MeetingType which indicates which type of meeting it is. There is a record for each scheduled meeting, and each meeting is further qualifed by field:Academic Year. I need to track attendance to each of these meetings. Table:People tracks everyone in my DB, and any subset of those people can attend both types of meetings. I need 2 layouts -- one for Faculty Meeting attendance records, and one for Council Meeting attendance records. Each layout script will generate a list of only those people eligible to attend th…

Hello, I have searched the file maker 8 user guide and many websites but can't find any thing about one-to-one relationships in filemaker. Does anyone have an idea about how I can set this kind of relationships. Thanks in advance ;)

Here is what I'm trying to do. I have a FileMaker file(A) with over 800 records in it. I want to create another FileMaker file( that will browse the first file. That way I can make updates without requiring the end user to re-import their entire database. My question is. Is there a way to browse all the records in File(A) through one record in File(. Otherwise I would have to run a script that creates a new record in File ( for every record in File (A) and then import the keys from File (A). Is there a better way of doing this? Am I going about this all wrong? Any help you can give is much appreciated.

Hello! I have just upgraded from FM5 to FM8.5Advanced and whoah....it's crazy. I am having a hard time wrapping my brain around the table situation and all these new relationships. My problem is very simple: I have an inventory database that contains the item code, item description and item price. I have my mainframe database which I would like to display these values when the user chooses an item description. I created a relationship between the mainframe item description and the inventory database item description. I then told the item code and item amount fields in the mainframe db to lookup the values from the inventory db. In addition, I also made the mainframe …

OK - in short, we have a database to track grants. So there's contact table, a grants table, and a milestones table. We have relationships that tie the contacts to the grants and then relationships that connect the grants to the milestones. Under the main - Contacts layout, I want to have two tabs, - one tab portal that lists all the "pending" milestones per this contact, and one tab portal that lists all the "completed" milestones. I'm trying to figure what fields (calc) and what relationships I need to set up to do this. So I want a relationship between Contacts and Milestones that filters/separates by whether the Milestones are completed or pending. I'm having trou…

I've got two tables, a Client table and a table that stores changes to the services that they subscribe to. What I am looking for is a field in the clients table that stores the number of records in the changes table that have a field set to 'N'. I set up two new fields in the clients table. One is where I want to have the count, the other is a Global that contains the value 'N'. For the count, I'm using: Count ( Changes::posted_to_clients )I've also set up a new relationship between the two tables where the keys are Clients::client# equal to Changes::client# AND Clients::globalvalue equal to Changes::posted_to_clients. When I set this up in one database as a t…

My brain is ready to explode. I have a datbase for case management, and I want each client record to have a contact log. I have created a table "contact" which contains these fields: Date, Notes, Type of Contact, clientid_pk. I have linked my clientid_pk to the contact_fk serial numbers under relationships. I want to be able to go from my main client layout to my contact layout, where I can enter and review dated notes for just that client. I have no clue what I am missing - I've tried several things and just can't think this one through. Any advice would be a tremendous help to my sanity.

Hope I'm in the right forum (if not please move me!). Is it possible to take several FM6 databases which are relational, and turn them into 1 FM7 database as multiple tables? If so, how??? :-)