Relationships

I have a query,I have repeating fields called ship to city,freight code & shipping rate. I want to select a shipping rate from another file which has freight code,shipping rate and Ship to city. The freight code for the first file is looked up from a third file and stored.How will I set a relation which will get me the shipping rate when the freight code is entered and ship to city is selected.I don't want to change to portal as many calculations are already set.

Hi, I have a button pointing to a related record in another d/b in a script. d/b 1, script1: go to related record; goto external script in d/b 2. d/b 2, script1: go to Layout Main The problem is that if there are no matching related records, it still goes to the layout in main to the record it was last at which is wrong. It should have a message saying "No matching records" Is there a way to prevent this? For example, is there a way to say "If (no related records) then..."? Thanks!

HI: I want make a report from 3 related DB but I can't, I want make information from PAcients DB and PricesA DB and PricesB DB in one DB call it reports DB, the master DB is Pacients DB. The report is the next: Pacients::Name PricesA::date PricesA: :payment PricesB::date PricesB: :payment I don't have any relation with the third DB (reports) can I make this report or could you suggest me somethin else? Thanks for you help [ June 18, 2001: Message edited by: LiveOak ]

Help I have a database for correspondence that gets the company details from one DB, and the Person details from another DB. Using a series of scripts to concantenate the various record id's and pull into the correspondece DB, then break up the record numbers again to use for the relationships this all works fine. The relationships are all defined correctly, yet the relationship that filemaker gets for the person details is totally incorrect!!! to give you an idea, this is the concantenated unique ID no's and they are unique as I checked them: 306200110261512641537IB 64200117521212599582S on the left is the person contact no on the right the company id no thus t…

I have 4 repeating fields L$,D%,D$,S$ L$ is available all the time. If D% is entered D$ & S$ should be set with a calucation involving L$ & D% Or If D$ is entered D% & S$ should be set with a calucation involving L$ & D$ Or If S$ is entered D% & D$ should be set with a calucation involving L$ & S$ No Button can be used to trigger a script. Please reply to [email protected]

okay i've tried everything i can think of and this is driving me nuts. here's the setup: FM Server 5 on NT4 hosting 30-file solution. Cross platform clients, all get in to Main file just fine except my G4/9.1. I keep getting the network hang (squiggly line) that lasts a solid 5 minutes when trying to open related files. and it's not always the same file causing the hang! i've tracked down a few, let it open, then i open the relationships window (another 5 minute hang), and redefine the relationship using the hosts button. this seems to solve the problem for that session but after quitting out of FM it occasionally it pops back up. again, i thought it was a mac issue bu…

Hi again: I try to make a DB, "OT" is the master DB this have a 26 fields I want a copy of any new record in another DB (Prod DB, this have 6 fields), just I need copy 6 field from the master DB when I capture it in the master DB, Can I make this?? i.e. fields From OT DB To Prod Db Name Name Last Name Last Name Age Age Birthday Birthday Phone Phone Pay Pay Maybe with a lookup works, please letme Know, thanks for any help God bless you soriano

And what exactly is a record in the New Position db? (and how is this different from an "Old Position" or when is a "new" position no longer new?) -bd

I have 2 related databases, Clients and Parties in which several parties are related to one client by a specific relationship titled Mother, Father, Son, Daughter. In the Party database is a Score field. In the Client database is a score field referencing each relationship i.e. Mother:Score. or Father:Score, Son:Score, Daugher:Score. My objective is to select the relationship which has the highest score so that the other fields in the Party database may be referenced by the Client database for the highest scoring relationship. Is there a way to accompish this??

Okay, I have 5 databases, all related by field: UID. No access privileges set yet. So, I have "allow creation of related records" checked for all relationships. Yet, when I type a UID into a new record in my central DB, nothing happens in the other 4 DBs. Am I missing something completely obvious? feeling wicked stupid bevin

Question: How do I duplicate the entire record including the related records in the portal? When it duplicates the form's ID increments and the related records are based on this ID. When I try to duplicate record, the related records in my portal is not copied over. Help.

I'm trying to create a relational database. In the first one I will have the client's records with the account numbers and subaccounts, and also the starting balance allowed for those subaccounts. My basic question is how do I write a calculation that will subtract the entered amount of money from the "starting balance" in the subaccount; and then when I enter another record, it will subtract from the "current balance", not the "starting" one. Thanx ahead.

I'm working on a database to keep track of some lawsuits. Each plaintiff may list several accused and each accused may be accused by more than one plaintiff. I think I need to set up a many-to-many relationship, but I haven't been able to make it work. Any suggestions? Each plaintiff has a unique number as does each accused. I have a Plaintiff.FP3 and Accused.FP3 Do I need a join file? And what should my relationships be? Thanks for your help! LR

I understand the many to many and have several solutions where it's working fine. However, in each of those solutions there is a lookup in the join file to the other many (invoice file has portal to join file which looks up product information in product file). However I'm now interested in redoing the payment file which is currently a one to many (one invoice has many payments and each payment is associated with one invoice and is entered in a portal on the invoice window). If I want to make this a many to many there is nothing to lookup so how do I populate the new many payment file? Right now it populates itself because the relationship allows creation of records …

I have a file maker file which handles my inventory and one file maker file which makes the invoices of the merchandise I sell. The description fields of the invoice file are linked to the inventory file and this way i don't have to type the description of everything i sell, but just select it from a pull down menu. I also created a relationship so that the price was automatically "pulled out" of my inventory file and entered as well. What I want to do is that everytime I complete an invoice, file maker automatically deducts the quantities of the items I sold from my inventory file. Right now what I have to do is open the inventory file and change the quantities manually…

I have created a db in FM 4.1 to calculate a control number (to be used in illustrations for tech manuals) based on information entered by the user. This information includes things like: Manual type (entered by clicking the button for the appropriate manual) Chapter (2 characters, entered manually by user) Section (2 characters, entered manually by user) Subject (2 characters, entered manually by user) Example: Manual Type: Flight Manual Chapter:01 Section: 10 Subject:01 Control Number: FM011001 My (main) problem is that this db contains 5 layouts which are used, depending on what button the user clicks (representing which manual the illustration goes…

I'm trying to write a solution that will track scores on graduation standards. There are 9 standard areas. Each student in each grade (K-6) does one assignment in each standard each year. So I have 1 class with many students; 1 student with many standards; 1 standard with many assignments (one for each grade); all tracking across multiple years. The final report will be a sheet for each standard/student (each student will have 9 pieces of paper in his/her file.), listing results for that standard from each grade. For data entry, I would like to be able to have a layout with a pop-up menu for the standard area. The user selects the standard and the assignments for th…

I have a relationship that can result in more than one result and only the first related record of any set are appearing in my related field (in alphabetical order), and I am wondering if I can (a) change that result to all related records or ( I can at least control the order that these results show up (as in something other than alphabetically). Can this be a useful way to implement repeating fields? Any ideas out there? Thanks...

I'm sure this is common but for some reason I just can't get my arms around this one. I'm creating a commissions tracking database for sales. There are three related databases: Sales Reps, Services and Main. The Sales Rep database holds a name and a group (group because not all reps are paid the same). The Services database has a Service name, Group A Commission, Group B Commission and Group C Commission. The Main database is where the customer information is entered, a Service is selected (Value List generated from Service Name in Service database), Sales Rep (Value List generated from Sales Reps database). Here is where I run into the problem. How do I get the M…

I am a relatively new FM (5.0) user so if I

This could just as easy gone in the Value List Forum: I'm having two issues with the a conditional value lists. First off. In the module that has all the different items to show on the Value lists, we have some items that have duplicate Form Names, but they can be told apart by another field. What they want is all of the duplicates to show up as well. I know that relationships just pull the first matching record, so is there a workaround? I tried adding the second field to the pulldown list, but it didn't work (i didn't think it would). Secondly, the same value list. There are some items that need to be in the value list no matter what. One way to do it would …

I am trying to figure out how to create a one-to-many relationship. I have a customer file and an invoice file. Each cutomer will have more than one invoice. I have been able to create a relationship by making a foreign key in the Customer file (cust|invID) and by making it a repeating field, I have been able to add each new invoice as it is created. But then I run into problems when trying to display this information in a portal, because it only displays the first related match information. I then read that it would be more versatile to make the foreign key a non-repeating field because you can then add thousands of keys to the field. Okay, I have done this but I ha…

I have 5 DB and I want make a report from a related DB and show me just the found in a search. for example: My related record is COSTS and I want a report of all the Low prices from this DB but search from the original DB, how can I do this? Thsnks [email protected]

I have a Software Problem Report (SPR) database (over 3000 records). There are six fields that, when modified, are put in (by hand) to MS Schedule. My problem is, I have to remember to check a "Schedule Affected" field every time I modify one of these fields. The problem is, each of the six fields are pop-up lists. For example, when the person responsible for the SPR changes, an "Assigned To" field is changed. I would normally put an "x" in the "Schedule Affected" box, but I forget sometimes. Is there any way to make these fields "trigger" a response, whether it is just a message/reminder when trying to leave the record or even a focus to the required field? I am a…

First of all I

I'm trying to design a database in FMPro5 to help track student records. We have about 600 students. Every year, each student is given 3 quick reading tests, in the Fall, Winter, and Spring, and various numbers are collected (Words per minute, comprehension %, and a few others). Every year, I would like to be able to add new reading results, while maintaining the previous years. Then, I would want to be able to sort and show... -a current class list sorted by teacher, showing all his/her kids and their current reading scores -an individual child and current and previous scores Right now I have a database with all the students in it, along with things like teacher…

I'd like to know when i create a record in a file how can this record be copied to an other file with the same information. Thanks for your help...

I am having trouble creating a relationship. This would be the sixth relationship in the database -- the other 5 work perfectly. This is not a <File Missing> error on a layout, but in actually defining the relationship. When I go through the process of creating this one -- I name the relationship, select the file to relate to my master db and even choose the match field -- then I click OK to create the relationship and in the relationship dialogue box I see <File Missing> for the new relationship. Any ideas what could be the source of this?? Thanks, S Tackett

I have a database that contains a bunch of unorganized info. I want to create a new file to get it better organized. I would like to know how to easily transfer the info back and forth. I would like to be able to enter an employee name into the new file and have it pick up all of the info in the record from the original DB. I should note that there are no value lists in the original. I noticed that when I create a value list based on fields from other files it gives me a nice alphabetized list. I wonder if there is a way to get that info out into a list of its own

ok.. this is a toughy and i doubt it can be done, but hey, you dont know until you ask, right? so i have two portals on a page.. both using the same relationship, but showing different fields in each one.. don't ask why, its hard to explain. now what i want to know.. is.. is it possible to have them syncronize... like if i select the 3rd portal row in the first portal the second portal with show data from the 3rd portal row. (did i forget to mention that the 2nd portal on the page only shows one row at a time).. i got something similar to work with a script.. but i didnt much like the way it worked.. wasnt very good..

I have one file, Invoicing, that has two global search fields (NumSearch and CodeSearch). The file has a working script, Invoice Search, that uses these global values in several fields to find an Invoice that has a range of Num values that incorporates the NumSearch value. More specifically, each Invoicing record has ten StartNum and ten EndNum fields (StartNum1, EndNum1, StartNum2, ...). The Invoice Search script finds any record on which the Code value matches CodeSearch and one of the Num ranges includes NumSearch. I don't know if all that makes sense, but that part is working. What I want to do is have the user be in a different file, Items, for which each Item …

I have a master database with names of 450+ students, used for them to log in and out of an afterschool program each day using CDML/Web page submit buttons. I've created a FMP script which allows the administrator to reset all students to "logged out" status at the end of each day (in case some of the students have forgotten) so the next day, all students need to log in. However, I also need to preserve a lasting record of which students logged in each day, and I'm not sure how best to approach this. I created a database with fields related to the master (students' numbers, date of log in, time of login and logout), and a calculation field which calculates elapsed time …

My structure: Starting point database of Projects; each project requires many deliverable Elements; each Element has many to-do Tasks to come to fruition. My challenge: I have reports designed at the Task level so that they can include details all the way down the hierarchy, like so: Project 1 ---Element 1.1 ------Task 1.1.1 ------Task 1.1.2 ---Element 1.2 ------Task 1.2.1 ------Task 1.2.2 ------Task 1.2.3 etc. At a certain point in our project planning process, some Elements do not yet have Tasks assigned but I need these Elements to be listed on some reports anyway (with no tasks listed under them). The report will not print Elements with no Task re…

I'm developing this training class for in house, course db, classes db, attendees db, line item db. So far everything is running smoothly but now the boss has introduced two courses that will not have "classes" but will be web based. So there's no new class with a time and place associated with it, attendees will just enter the dates they reviewed it. Any ideas on how to track this? many thanks, nati

Hi and thanks for this forum. I have the beginner questions. My friend and I have decided to create our database for our bead business. We have the client db, invoice db, payments db, line items db and product db all working. Now we want to create supplier db. We have 4 suppliers who each supply us with product, none of which are the same. So one product has only one supplier, one supplier has many products so this is a one to many. My question is since the price of a supplier product could change then do we need a line item file for this? I would think yes, but am not sure. Also, we do create a seller file, which is the two of us, but could be more. As now…

Hello I'm working on a project involving pedigrees. Each animal has a file which includes the following fields: ID Fathers ID Mothers ID From this type of file I would like to build a four generation pedigree (family tree). I can get the first generation (Father &Mother)with a self joining relationship. Can anyone help me with the next generations (gandfathers & grandmothers) Thanks for any help

I have a db invoices and one of vehicles. I've had them linked through a match field "license number". A friend tried my program and suggested using unique values generated by FM5 for the match fields. Could someom hjelp me sort this out? So far, I've had the user enter the license number on the invoice; then click a "new vehicle" button which called "new record" in vehicles and "set field" it's license to that entered in the invoice. I picture the new way having "new vehicle" put a serial number in the vehicle portal in the invoice then making a new vehicle in that file and pasting that serial number there for a match. If this isn't clear I apologize in advance f…

I have related two files: (1) An order entry database (master file) (2) An address database (related file) I have been able to get addresses out of the related file (address db) into my master file (order entry db) by creating links between the two files. That's fine. Here is my problem -- or perhaps these are two distinct problems -- when I am entering a new record in my order entry db (I use the company name as the "trigger" field) FMP5 will only copy the company address info into my order entry (master) file if I type in an exact match of the company name I have in my address (related) file. But I would like to be able to type several letters of a company name and …

I have a course db, a session db, line item db, and a student database. I add the students to the course through a portal in the session db. Is there a way I can also go to the student db, find the student and add them to a course from the student db file? Many thanks, nati

I am a very new user to FileMaker (4.1 unfortunately) and I had to jump in with both feet. I am trying to create relational databases but I am obviously missing something. I have a related database which contains most of my information and I have a created a master database (which contains 5 fields from the related database as well as some new ones). I want to be able to post my information in the related database and when I open my master database I want the information from the related database to be there - then I can imput my additional data to all my other fields in my master database. Then when I update my related database I want it to "copy" the new records to …

I've been appointed the lucky person to develop an inhouse training database. I have a few questions if you don't mind. There will be several courses, each course will have many sessions and each session can be attended by many employees. I'm seeing this as course to sessions as 1 to many, sessions to employees as many to many with a join file. Some of the requirments are quarterly reports on courses, reports on completed sessions by employee, reports by year, etc. This should be pretty straight ahead or am I missing something (yet again!) many thanks, nati

I'd like to know why how to otimize my find results when I use relationship fields in it... If someone could help me.....Thanks

I have two db FM5/w98 with contact info. The master file uses a calculation match field which concatenates first and last name. The related file uses a concatenation of it's first and last name fields.They are set to create new records from the master file. When I enter first and last names in the master file and attempt to enter related field data such as a phone number, an error dialog appears saying the relationship is not valid. I realize pairing two calcs might be asking a little much. Other files that use more conventional matches are allowing record creation with the expected ease. Thanks, Bill

I have a database called versions. there is a job number field in this database. there may be many records with the same job number (different versions of a project). There is a field called sales status. This field can have one of two values - "Available" or "Sold." I'd like to be able to have a calculation field that would tell me how many versions with the same job number have been sold and thus have the value of "Sold" in the sales status field. i'm so far havin no luck. any suggestions?

Hi, I'm trying to set up a relationship between two files, where the match field of related records will be "less than" the match field in the master file. E.g. if the match field in the master record is a date, I'd like to find all related records that have values in the match field that are before that date. The FM5 help says that match fields can contain a calculation formula (the example they give is "Unit price < 100.00") so it seems possible to do this, but I cannot for the life of me work out what it is the help file means! Has someone successfully implemented such a relationship? Thanks Rob

I want to be able from one feild, to select an item from a drop down menu, that depending on what I choose from there, changes the options in another drop down menu. example: Subcontractor (Drop down menu) Description (Drop down menu) depending on the subcontractor, the description menu will change specifically for the sub chosen. Any help would be appreciated....THANKS!

Hello, I have a db Personnel that has straightforward contact info. Another db Contracts has fields for, say, Manager, Foreman, Straw Boss and Paymaster. What I would like to do is create some relationships so that when the user enters a Foreman's name in Contracts, if it matches a name in personnel, related fields display the appropriate contact info. At this point, entries in Personnel are "equal" in that they are not flagged with roles Manager, Foreman etc. The reason for this is that the individuals could be Manager on one contract and Paymaster on another. I have lots of other relationships not needing any couples therapy but this one has me stumped for a desig…

G'day folks I'm building a database of little chunks of gene sequences [alphabetic only text strings uup to around 150 characters long]. Each sequence must be uniquely numbered with later occurences of the same sequence inheriting the same number as the first. To do this I've created a lookup database with the first occurence each string and the ID number assigned to it. The files are related through the sequence fields and the ID number in the main database is defined to autofill by lookup to the lookup database. New data is imported as sequences from spreadsheets and if a sequence already exists it inherits the original's ID number and those that remain are then given …

OK, Part I: Can one file have different relationships with different files of the same name but in different locations? For example, can "file1.fp5" on "Server #1" have a relationship with "file1.fp5" on "Server #2?" --or a remote server with a static IP address? Part II: Can "file1.fp5" do imports from and execute external scripts in the remote "file1.fp5?" Part III: Can "file1.fp5" perform the above-mentioned tasks in relation to a number of "file1.fp5's" in various static remote locations? Gracias in advance, DB

I am working on 'fixing' a part of our company's invoicing program that uses repeating fields. Currently we have a 'payment entry' window where payments can be entered to close or pay against a particular invoice. The fields are 'Date Paid', 'Amount Paid', and 'Payment Details'. All of these are repeating fields. The second file we use is for printing monthly 'Invoice Tracking' reports. A date range is entered (a month) and the reports displays a list of all invoices paid in the date range. Here is the problem: The report that gets generated is accurate as long as all of the invoices were closed within the date range. However, if an invoice is NOT closed and only…

I have a program - clients/ invoice/ line items/payments. I just added a insurance file that relates to client file. it has a join file. Client has a primary insurance company and secondary. What I would like to do is in the invoice file show the clients primary insurance company. What relationship do I have to setup to show this or what's the best way to do this? It's driving me nuts! many thanks, nati

This may be simple but I can't seem to figure it out. If I have two files, say "user" and "service". I've created a relationship on "userid"--a field that I've placed in both files. I'd like to be able to associate (relate) a particular user in the user database file with a specific service record. Rather than having to type the user id in the service file to relate the two files, I'd rather have a pop-up list in the service file that allows you to select a user from a pop-up list. Even though the selection is made on a user name field, I want the relationship to be set on userid so that, if the user name changes, the relationship between this particular service record an…

I have 3 relational databases 1.for employee data, 2. for courses taken by each employee, and 3. for course identification (course name and hours). I am able to calculate the total hours for each employee in 2. courses taken by employees database by creating a summary report. My problem is that sometimes I need to conduct a query on staff that has taken more than or less than a specific number of hours. I have been running a complete report for all personnel in a specific department with all the totals for each one. Then I manually find the people with totals over 25 hrs. This is a very time consuming process. There must be some other way to do this. Thank you in…

You can have a TownID field in the inscription file that is set to the same TownID as in the client file. Then create a direct relationship to the town file. Then you can display the town name using this relationship. Alternately, you can create a town name field in the client file which is an auto-enter value looked up from the town file based on the Town ID relationship. You can then access this field in the inscription file.

Ok here the situation, i got 6 different files and i want to use one of those files as a "search file" in which all the fields in the "search files" would be able to search in the other one. In all my files i got 17 fields that are the same. Now how would I proceed to create this search file so that i would be able to go in my "search file" and type a name or a last name or name of a street or even the name of the city. and it would search the other files.

Here's my problem. I volunteer for an organization that wants to track attendance of youth. Each youth has an ID number. I've set up a layout that tracks the week, the days, and the ID. How do I tie the ID to the date so the same set of ID numbers can be used for next week's data and so on? Is this a role for a portal? Lookups? I'm afraid I'm a rookie and stumped. Koaxfrax

I have a file that contains names & data on those names. The name is broken up into 3 fields, First Name, Last Name & Middle Initial. I then have other databases that I want to import data to, once the record is matched to all 3 of the fields FN LN & MI. I can only find that I can create a relationship to ONE field. Does anyone know how to create relationship to all 3, so when FN LN & MI match it will bring certain data into the other files?

Hi, I am a relative newby at Filemaker, and I hope someone can help me. I have a database with five relational files (related on unique ID numbers). I have a number of layouts, calling on fields in any one of the five files. What I want to do is input names into the main layout page, then move to another layout which shows whether the person has contributed to the organisation before. I have a tick box which when ticked automatically generates that person as a contributor. In the related layout, the person's name is only shown if the person is a contributor, together with their unique contributor number (not the same field). This worked fine when I had the five di…

I have a DB that keeps records of various kind at an elementary school (I work for a school district). The "students" are in one file and the "activities" are in another. (There are a couple other files, but they aren't affected by this issue) They are tied via a student ID number. Because of the way schools work, I delete all the records in the "student" file and replace them each year in the fall. This of course, leaves some orphan records in the "activities" file. Is there a way to identify those orphaned records after I do the "student" reload and get rid of them so the "activities" file doesn't keep growing? ------------------

Could anyone shed any light on my little problem? I have written a billing application, which pays out commissions to sales agents. The agents are paid commissions on received payments only. Whenever an invoice is printed, the BOOK database is updated with the relevant information needed to provide the customer with a statement of account. I also use this database to calculate the agent payouts. There are two payment types in the database: PAY (money received) and INV (bills sent). Usually the client would pay an amount that would clear the amount owing for that invoice. I say usually, because he may pay more or less as he wishes. For all intents and purposes, though, …

I have created a database comprised of about ten different files each of which is related to one or more other files through relationships as well as scripts. This database is to be copied and used for a multitude of different projects. I would like to give each file in a project's database a unique name, specific to the project, in order to avoid cross-referencing of relationships and scripts. The problem is that once a file name is changed, the relationships and scripts do not work. The obvious solution is to update each relationship and script once new file names have been established but this is time consuming considering the quantity of relationships and scripts tha…

I designed a database for my small business and it has client/invoice/line items/charges and payments files. Currently the payment window is in the invoice file and each payment is associated with an invoice. Now I'm thinking I'd like some clients to have the ability to run an account instead of cash and carry and I'd like to change it to have the capability of the partial payments from a client. So if a client has 12 invoices and they come in and pay me $100 I'd like to show their balance and enter the payment and then the new balance. Is this hard to do? I'm new at this and modified the Filemaker template to make it work for me but I'm stuck on this one. Many tha…

Over the years I have developed a number of different databases for a company that I work for. Although the databases could have been related, they have not been for a variety of administrative reasons (namely, inter-departmental power struggles). I have recently convinced the powers to be that ideally all of the systems should be integrated together and am trying to keep the momentum rolling. My problem lies in the design of the database structure as there is one piece of information I am not certain how to setup. The system starts as an employee personnel system and expands into tracking employee status/history, dependents, employee attendance/sick days/vacation, em…

I have the following situation, and it has probably been answered here several times, but I haven't been able to find a solution. I am trying to related a master file to a contact file where someone entering in data can pick from conditional popups, and add new items if needed. Say, Customer Name Customer Contact (multiple per customer) Product (multiple per customer and mulipule per contact) Product Division (again, per customer/contact and product) The trick is, I want to pick a customer and see only contacts for that customer, then pick a contact and see only products for that contact, then pick a product and pick from only products for that product. But, i…

I hope this isn't off topic. I'm looking to set up a database for an on line clothing store, and am trying to figure out how to handle the fact that many items will come in differnt sizes, etc. How do I set up a database so that a user will be able to select from several different sizes, and perhaps even several differnt colors for a particular item? Of course there will be different options for each item, and I need to assign options for every item available. Can somebody point me in the right direction? Thanks. --Alan

I have a titles/authors system in which one title may have many authors and one author may have many titles. I understand the concepts of the join file and record IDs. What I want to do is to have the user create a title, then fill in the authors via a portal. I'd like to have each portal row have a drop-down value list of authors because the authors database will have contact info. I'm having problems setting an author ID to a particular title ID in the join file. I hope I explained my situation well enough. TIA. KenL

Hi there, Just started using FMP5 and I hope to get some help on the next one. I have two different files (let's say: file 1 and 2) joined in a joinfile (file A). I did the same with two other files (file 3 and file 4, joinfile :, so far no problem. Now I'd like to join file A and file B, but then I get a message that the relationship I used is based on a calculation, and therefore the relationship won't work. Although I defined my relationships purely on unique ID's of files 1,2,3,4. Hope I explained my problem clearly enough and I hope that somebody can help me on this? Thanks in advance.

I develop on my Mac and deploy on Windows NT in my office. I realised that the relationship file reference get lost after I moved the database on to the Windows NT from my Mac. Is that a way to prevent this without needing to select the related file again after the database is moved to a different platform? This is gets worse when I am working from remote and the only way for me to get my database to the Windows NT is via ftp. Then I will use the dbopen or dbclose CDML to open or close my database remotely. With this method I can never get the database running properly after I make modifications on my Mac. I will have to physically get to the location where the Windows N…

Hi. I have an athletic scheduling database of 7 sports for an athletic conference. Each contest has its own record, and I'm using a self-join relationship w/ the date to summarize all contests by date. Using sub-summary by date and portals for each sport, I can get an okay table: DATE Fball Men's Soccer Men's CC COR@Y B@H COR@Y B@H The problem is that each record has a total calculation field for Teams 1 and 2 that generate the A@B. It also has a sport field. Finally, there are calculation fields for each sport-->fball: case(sport=fball, total) That's how I get the contest to appear under the correct sport heading. However, for each s…

I have two DBs. One contains classes That I teach. Each record has an ID# and description. My second DB lists my students and the classes (five) that they are scheduled to take. My relationship is the Class ID# between the two DBs. I don't seem able to display multiple classes for a given student. I can select different classes however, only the first classes description appears in each of the five fields I ahv set for classes. Suggestions would be most welcomed. Thanks in advance.

I use a DB to create a list of classes that I teach. A second DB is a list of students with misc info on each including the classes they are taking. If I make a change in a class or correct a typo the student files are updated and everything is great. A third database tracks detentions for students. I want the class to be included in this DB. The class information will not show up. Is this an issue with FMP? I generally use Access where there is one DB and multiple tables. If this is a restriction in FMP I need to rethink my DBs. Thanks in advance.

I want to be able to paste the contents of one field into a second new field, if the value in a 'third' field is met.. (all in the same data base file). How can I do this? Graham ------------------ Graham

Hello I am creating a data base to more efficiently generate a medical case mix report I have several databases (files) amongst these are 1 a case mix file containing a form/layout for the "Principle Diagnosis" 2 I have a separate file of medical conditions which will have the following fields <Organ System> <Subtype> <Diagnosis> thus for example Organ System Cardiovascular Subgroup Medical Diagnosis Acute Myocardial Infarction Organ System Cardiovascular Subgroup Surgical Diagnosis Repair of Aneurysm Organ System Respiratory Subgroup Medical Diagnosis Chronic Obstructive Pulmonary Disease …

Hi, I am attempting to develop again in Filemaker after not using it for awhile. I have a demo version 4.0 that I am using to see if FIlemaker can fulfil my needs before I buy developer. My concern however is speed. I have several files in the solution one of them being an Inventory file which is linked to a purchase file and an inventory use file. Therefore through relationships and a calculation field I am updating what the inventory level should be. I am concerned about speed when more records are placed in the file. I seem to remember that the more records the slower the refresh when moving through the file. Should I try to update the level of inventory via a script…

Howdy, I've got two files, one with employee names, the other with training session summaries. The training sessions always have two employee trainers and two employee students. Currently we enter the four names manually in each new training session record. I would like to be able to type in the last name of the first employee and have a pull down menu to select valid employee first names from. If the last name returns no first names, or if none of the first names match I would like to type in the new first name and have a new record created in the employee file to match. Then the same would be repeated for each of the three remaining employees. Info about the trainin…

Howdy folks, Appreciate any responses on this one. I have frontend and a relation which holds all my value list data. This is Collections dbs in small museum and I have migrated 25 curator dbs into this "single" stack and are now trying to clean up categories/value lists/ to function across multiple accesses. Everybody is accessing it from FMP 5 and I have a FMP Server 5 sitting on an NT box. The frontend holds several categories of material and is used by users with access limited to sets of categories - limited by loggin & a gl;obal field. Works fine - to point, more on that latter - but I can't get the value lists to show when they go into Find mode. I've…

Trying to figure out the best and least cumbersome way to find data in a related file if it is there, and still have the user type in info for a new record if not - all in the same set of fields. Are the only two ways to do this a portal or a calculated match field? Is there a slicker way of doing it? Portals will look bad in my solution and so far calculated match fields are the best option I can find (if a little cumbersome). Anything I am missing? Thanks fo any ideas...

I live in fear of closing my data base. I have two related files. The relationships go both ways. When I try to close the files, without quitting FM 4, I end up in a loop where closing one file launches the other in the background. Eventually I have to quit FM. Yesterday the files became corrupt. I was able to recover, but it wasn't pretty. I suspect that the corruption had something to do with the way I closed the data base. What is the best way to close a related data base?

Hi to all, A few months ago I posted my first topic and received a helpful answer, Thanks, guys. I have a database that actually holding info. and another just as a FIND and LOOKUP, I manage to get it work pretty well though scripting. But I need to be able to do the same info from the same DB. but through Claris HomePage. I have repeated field with some basic calculation in DB that contain info-- QTY,DESCRP, COST,and TOTAL each being orginize by Job# so 1 Job# would have several records In the FIND field, I have JOB NUMBER that shows all the record that link through that Job# field on both DB, but I cannt seem to pull that off with CHP. The Portal in CHP…

Hi all. I hope I'm posting this question in the most appropriate room. We have an fmp file we use to serve our website and to preview and print fmp reports from. The problem is that when the file is in preview mode the website can't access it and website users are interfered with. The best long term solution would seem to be having the reports built in a seperate file so that there would be a master file that stores the data and serves the website and a second file dedicated to reporting on the master file's data. How is this accomplished. (Please be as specific as you can. I have a developer's background but I'm relatively knew to filemaker and so far I'm accustomed …

I'm still learning the rules of calculations. Can someone please give me an example of how exactly the formula should look. The field name being tested is CLIENT and the first test would be HOUSE with the result being OSO1 and the second test would be HOUSE 2 with the result being OSO9. Thanks a lot!! Case ( test1 , result1

Having worked for many months on a solution related to my line of work, I am only just entering the relational side of things as I write this. I have a good book that I am reading and yet I am either missing a few basic things or am biting off more than I can chew. I want to pose a simple question so I may understand this a little better. Case: I have a file of 'events' that are usually days where an actitiy occurs and I want to relate it to a file of hotels that is continually growing and accessible when the information is already there from a previous 'event'. Since this is a possible many events relating to a possible many hotels, is this therefore a many to many relat…

Have created a correspondence data base related to a contact data base. The idea is to write letters and get the pertinent address infor from the contact DB. The shared link is "last name". The problem is when I put in a common last name such as "Smith" the correspondence DB only gets the info on the first "Smith" in the contact DB. How do I make it so I have a choice of which "Smith" to use.

Here is what I need: In an Invoices file where I have to enter the data of my Customers, one of the fields is Category ( it?s defined by a value list), and the Price of the Product depends on Customer Category. In the Invoices Layout I have a Portal to Articles Sold and when I add a new Invoice and the Category changes, then I need the right Price for that Category. In Articles Sold when I take a Product by his COD there is a match to COD form Products but I need to have the right Price when the Category of the Costumer changes, and I can?t accomplish that, every time the Price is the repeated from the first match. In Products file I have two different prices that…

Hi I'm not sure if I've got a logical problem here or what, but I'd appreciate any advice. I have two related db files. The first is kind of a master interface that collects and displays information from the second, related file (it also has its own dataset, but I don't think that's relevant to the problem I'm having). What I'm trying to do is allow users to key in a chapter number in the master file, which will be written into the secondary file. Once that number is keyed, a second field in the related db should be automatically filled in by picking up the value from the previous record. What's actually happening, though, is the autoentry field is picking up the data…

I am setting up an Input File that includes 90 unique tasks in each record. They have been set up to provide the name of the person that is assigned to that task (Pop Up menu from the Staff file). Everything works fine there. Now I need to extract the names of all of the people that have been assigned tasks within that record and put them into a "Team" field. Obviously, I can't use 90 names and in every record there are multiple tasks assigned to one name. So I need a listing of all of the unique names to put into the Team field. I have tried Defining Values, Setting Up relationships, creating a script and I still cannot get a list of just the unique names to make …

Does anyone know of a way to have values from multiple relationships in a Portal of a different Relationship? Whenever I do this, it fills in all the rows with the values from the first record of each of the Relationships...

Does anyone know how to number rows in a Portal? Thanks! Jeffrey Ellis

I'm making a schedule; would like to have a list of dorm rooms and beds (probably in one db) and a list of names in another. Would like to assign a room and bed to a person. Then would like to be able to bring up the room and see what person(s) have been assigned to that room.

After using several relationial database systems I am trying to implement a similar structure in FMP. The current problem is the retrieval of data using a WHERE clause. I have a two tables linked with a one-to-many foreign key. I would like to populate the master record query form with data from the linked table. This I can do using a portal. I would then like to restrict the rows retrieved. In other systems I would use either a VIEW or a simple; SELECT * FROM TABLE WHERE CONSTRAINT = VALUE How is this implemented in FMP as I cannot currently find a way without having to write a large number of scripts.

I am a baby at FM 5.0 and I created an employee database and related it to a project db with project # as the key field. We built a portal on the employee database that has a drop-down field that gives the project number..we would like the right project name to pop up in the standard field right next to it. I got it to work by inserting the drop down project # field on the master file (after relating it to the project number field in the related db). Well, sorta work, because the name pops up ok, but the number repeats itself in the next row of the portal? I have no idea why this happens or how to fix it. HELP!!!:

I guess this is a silly question but I didn't find it in this FAQ. I'm performing a -Find action to the database and in the response web page I'm using the tags : [FMP-Record] to display the set of records found, now, how can I display only one time records which have the same value for some specific field. That's simple using SQL, its' something like : SELECT name DISTINCT FROM table_name. I'd really appreciate your help. ML

Hi to all, I'm a fairly new user in FM Pro 4.x. I've create a db ,with typical fields-date ,qty, product,cost,ex-cost,sub ttl,etc. The Qty,Product,Cost are set as repeated field, so it holds 3-4 lines of entries in one record. These record are identify by MPO#, and being organize by Job# so in one Job# would have multiples Mpo#. I've match (Job#) which is not a repeated field for a look up . My problem is that, when I link the data through portal with Qty Product and Cost. I've set these field as repeated field inside the portal and it seem that these records are overlap eachother. For example, The 1st line of the 1st entry of the 1st record is fine but the …

Ok, I figured out a better way of handling this. Instead of [rate] being a calculated field, I made it a Number with an Auto-Entered value of the rate from the Category database. Thus, by default it shows the true rate, but it can also be modified. Problem solved!

quote: Originally posted by Jeff Abraham: I have an employee database that is related to a customer profile database. In the profile database the related field (employee name with 25 repetitions) is based on values in the name field (1 repetition) of the employee database. I want users to select an employee name in the profile database and have all of their employee information automatically added to the profile database. This works great for the first repetition but it does not find the data for any other repetition. Any help would be greatly appreciated! Thanks! Repeating fields do NOT work with relationships. Only the first value is indexed and used. Brea…

I've used this feature a half dozen times before and now all of the sudden its not working. I have two files we'll call Parent and Child. The Parent file has a fields called Customer ID. The Child file has a field called Cust ID. Both are of type TEXT. In the Master file I have a relationship defined between Customer ID in the Master file and Cust ID in the Child file. I have the "Allow creation of related records" option turned on for this relationship. Problem: When type Ctrl N to create a new record in the Master file and then I enter data into the Customer ID field for this new record, no new record gets created in the Child file. Why the heck not? This is exactl…

After assembling related databases to one database, fields which should have the same contents as the previous records remain empty. This make it not possible to make searches. How can I avoid empty fields? thanks, charles

I have 2 databases: 1) a Project profile(contains project specific information ) and, 2) a budgeting database (tracks all invoices) I need to be able to show dollar totals on the "project profile" database by department. The buget database has a department field to differentiate the records and i have a relationship tied to project total. I cannot seem to get dollars seperated by department. i am lookig for a "Sum If" like command. Thanks!

If I have a main file with 15 records, once I match the first record in a related file, shouldn't the remaining 14 records automatically be created in the related db? If not, is it possible to make this happen and if so, how? Thanks.

Hello to all. My problem is as follows : I have 2 files, one lists financial operations, let's call it "expenses", where an entry is an operation. The second is a schedule, where an entry is a month. How can I link a recurrent operation (for example the same operation will occur once a month for 2 years) to that number of monthes in the second file ? This is quite basic, but I am unable to find the way. Thanks to all (at least for reading my poor English). == tdml