Relationships

Hi, I have an Employee file (EmpID as primary key) and Attendance file (EmpID as foreign key). The Attendace contains LogDate {date}, LeaveType {text}, and LeaveCount {number} fields. What i want to do is to display in Employee file total of LeaveCount per year per LeaveType in each employee record (browse mode). I've tried creating a relationship using calc multi-field combination of EmpID, Year {from LogDate}, and LeaveType in both files but i can't get the right output. Any help?

i am sure this is simple, but i have yet to work with relations. This is basic. I have a customer db, when i import from a file i import the customer info and the book sku. I have a inventroy db with all item info in it. I would like the customer db to update the item info based on sku. so, i would import the customer info, and sku, then fm will update the item info based on sku. how do i do that? thanks

We have the situation where certain users cannot find a related file which is stored on another server. Has anyone experienced this? I took the parent file off-line and related to the child file (on its server) but still no joy. Should I relate without the path box checked? Joseppic.

This is probably simple but I'm struggling to figure it out.... How do you create a deletion rule which prevents a user deleting a parent record if it has any children thus avoiding the possibility of orphaned records? I guess it involves the "when deleting a record in this file, also delete related records" checkbox in the edit relationship popup however as far as I can see checking it will result in parent and child both being deleted and leaving it blank will result in orphans. I'm looking to implement a solution that forces the user to delete any existing child records prior to being able to delete the parent. Any advice much appreciated. Iain

Imagine a portal of appointments. Imagine not wanting to book an appointment on the same day, at then same time, as another entry. Imagine a waterfall, with laptops floating downstream. Basically I'd love there to be a "Unique" checkbox for a calculation. Instead I need help creating a relationship. That's my guess. I have searched the forum with no luck.

Help..... I have a database where i have I set of records for quarterly data, and one set of records for annual data, which are linked by a FUNDID field. What I need to do is: View a fund One column for quarter ending 30/6/03, and the next column for year ending 30/6/03 so i can compare fields. Is this done using an internal relationship, summarised in a portal? If so how...

Hi Guys, I am new to file maker and hope to get some answers from you. I've been reading through thte forum but couldn't find anything that would help. Here is my problem: I have two related files. The relationship is based on the phone number. One file has item_id, customer_phone_number, phone_type (4 types possible from the value list - home, cell, work, other), salesperson_name. The records in another file are imported from the Excel spreadsheet - it is only phone number. After import, I need to look up information for these imported phones. The problem is that I need information only for home phone and if this one doesn't exist, for cell phone (not for the re…

I've read in the forums that you are not to print portals because they cause inherent problems with the printout. Right now I am in the process of creating a report with a one-to-many relationship in several fields, and I need the "manys" printed for each "one" record. I cannot access these via a portal for the printout layout. Can someone give me an example of the proper way to access portal fields for printing? I've been told to use a calculation to copy the information to a text field and then access that text field -- please if someone could share an example of this. Thanks. Chris

Hello, this question my sound stupid. i have relationship between db A and db B. when i open db A, db B gets open because of the relationship between the two. Is there a way for db B not be open but still function properly, since both file are on the same fm server? thanks, victor

I currently have a contacts database in which each contact type is designated by a value list. I would like to create a related database for each type in the value list. So for example, I would have a database with all the "Personal" contacts from the main contacts database in it. I'm not sure if this is impossible or even very simple. I've played a little, but haven't got it yet. Maybe I should just make several new layouts in the main file? Or maybe the only way is to make each related file store the info for the main database as in any other many to one relationship.

Hi there, I'm very much a beginner in the many-to-many relationship arena. I've tried reading other people's postings and I'm still stuck on this subject because it's so new to me. I would love to hear any advice someone could offer on my specific situation. here's the deal... I have a contact database and a database of marketing activties (i.e. a mailing, call campaign, email campaign, etc.). On the contact database, I have a layout set up with a portal to view all marketing activities linked to that contact. On the marketing activity database, I have a portal set up to view all contacts linked to that marketing activity. each contact has a unique contact ID …

Hi, I'm new to FMP development. Please excuse me if i have been overlooking something. I have 2 database. First is Employee database with EmployeeID as key and another is Attendance database which contain fields EmployeeID, LogDate, LogTime, and others. I have created a field IDMonthYear (Text) in Attendance db which is set to 'EmployeeID & MonthName(LogDate) & Year(LogDate)' (text) thru a script. On the other hand, i created a field IDMonthYear in Employee db which is set to 'EmployeeID & Month & Year' (text) where Month and Year fields are set thru pop-up list. My objective is to relate the 2 db and create a portal inside Employe…

Help! I'm putting together a new database and a relationship is now causing a catastrophic error. The database has 1719 records (although it will grow to ~15000 over the next year if I can get this problem solved). Each record has a line # and an 8-digit coordinate (among other things). I want to identify all records that have a coordinate "near" the current record's. So I made a calculation text field ("coordinate list"), which generates two lines with the coordinate rounded down to the nearest 250 and rounded up to the nearest 250. This field is then used for a self-join relationship. The result is shown in a portal, generating a list of all related r…

I have been developing and deploying a fmp 6 database for my company for two years now. The issue I keep having is one of unrecoverable data. We do quotes for people, so we have a bid db and sub db called bid areas. The areas db is not large (13mb), but it keeps getting corrupted. Now the question, What are any items I should be looking for in order to fix this reoccurring problem. i.e. shut downs, improper relationships, anything that might be causing this. We have 10 files that relate and the areas db is the only one with problems.

Hello All, I pretty experienced with databases but haven't worked with FM since version 4 way back when. My problem is that I have a complicated layout built from many related child fields, portals etc that someone else built. What I'd LIKE to do is create a report with some complicated running totals and things like that concerning variables that all come from a particular child. I have created all the variables and summaries I need but my problem arises in selecting the group of files to report from. What I'd like to do is let the users select a group from the front end they're used to and then let them choose a report button and have it generate the repo…

Let's have 2 files: A, B. There is a relationship between A and B: A::keyb = B::KEYB Some of the record of B are: 1: KEYB=000A 2: KEYB=000B 3: KEYB=000C One record in A have A::keyb ="000A 000B" (note the CR between 000A and 000B) In filemaker 5.5 and 6.0 this record relates to both record 1 and 2 in B. In filemaker 5.0 it does't relate to any record in B. Is it normal?

I'm having some troubles creating a record in a related file. I have a database that collects sales request info from the web. Thats works fine. I review that info manually within Filemaker and submit it to the real database via a button w/attached script. The problem is submitting new records to the customer database. They are realated by CustNo relationship. I have a script set up to create a new record in the customer file, then use SET FIELD to copy data from the web database to the customer database. The new record is created, but the SET FIELDS are not working. I figure this is not working because the customer database is looking for a match in the web database…

Hi all, I am new to this forum (and to Filemaker), and I hope this is the right place to ask this question: I have a database where each record is associated with a variable number of images. so I have two related databases, a main database and a image database. Now I would like to be able to, in the main database, step through all related images (if I create a field that shows the related images only the first image is shown). How do I do that? Thanks! INgo

Hello everyone, I'm new in this company and I'am asked to make some changes in a FMpro application, being about 35 databases linked together. Before starting to experiment, I would like to have a (clear) picture of how these db's are linked together, I need to know which db links to another. Is there a tool that can draw me a picture or something of the complete application infrastructure. It really would help me a lot in understanding how this application works. greetz, bart

Hi Guys! I need to keep track of my budget as I'm buying supplies for any of the 3 media centers I'm in charge of. (They each have their own budget.) I have files Requisition.fp5, Line Items.fp5, and Vendors.fp5 which all work to create my requistions. I want to add Budgets.fp5 so that when I'm creating a requisition, I can see on-the-fly where my budget is at. I want to always know what my beginning balance was, as well as the remaining balance after each purchase. So it would look like this: Beginning Balance: $1000. Order #1: $50 Remaining Balance: $950 Beginning Balance: $1000 Current Balance: $950 Order #2: $100 Remaining Balan…

I have 2 fields that are repeating, up to 18 repetitions. One field is <ticker>. The other is <fund>. I have a rel. set up that brings in the <fund> name based on whatever ticker value I specify. However...the repeating fields below <fund> remain blank when I enter in new ticker symbols in the corresponding repeating fields...as if I can't use them in a relationship. I would like to have this relational ability w/ repeating fields in order to avoid creating 18 different fields by which to accomplish the same objective. So...is there a way to use a repeating fields (per individual record)in one-to-one relationships? Anything would help. …

[WARNING--LONG POST] Help!!! I'm a newbie with a big project who's building his first database while poring over Coulumbre & Price. The main purposes of this database are to: 1. generate e-mail, phone & snail mail lists of contacts subdivided by the following categories: Members, Contacts, Reporters, Editors, Photoeditors, Donors, Organizations, News Media. 2. Show current member status 3. display dues, special contributions & payments for services per given time period. 4. display group members by committee, skills, and activities. These are the main tables involved, along with their fields (most foreign keys omitted…

I am trying to set up an invoice-type system, except I'm on the other end of it. I am a school media specialist and I want to use FileMaker to create my requisitions. I used Hilton Brown's article "Invoices and Related Files" at http://www.jedi.apana.org.au/~hiltonb/ARTICLES/9804/9804TXT.HTM, and made a successful system (although I don't get why I would need the Products file when I have Line Items....) Anyway, I need to be able to *purchase* items out of a catalog, rather than sell from my own inventory. Hilton's solution works great if you know the inventory, but I don't want to have to enter the items I want to purchase into Line Items.fp5 and then go to m…

Hi everyone, I have been struggling over this for 3 days now and getting more and more confused. I have: 1. a nursing home policies file 2. a res home policies file 3. a domiciliary policies file In each of these files, each policy can relate to a number of standards in my: 4. standards file Equally, each standard may have a number of policies to which it relates, across all three policies files. i.e. I think I have a Many to Many Relationship issue. My problem is that I have 3 portals in my standards file allowing me to view the associated polices from each of the 3 policies files. The match field (key) in each of the 3 policies fi…

I have 2 filemaker files one is my main db the other a db i open from the main db. The problem i run into is that may secondary db has a startup script that gets ignored by my opening comand in the main db. Main db -> Click -> Open 2 db file -> ignores startup script. Any ideas?

This is my current solution: I'd like to delete all records from the Customers file that are not used in the RequestLog file. The match field is CustNo. Is there an automated or semi-automated way to do this? Right now I have a portal in Customers showing related records from RequestLog. I scroll through each customer record and if there are no related records in the portal then I delete it. This is slow and tedious. Is there a better way??? Thanks Mark Durgee

Hi there Hope someone has some practical advice about the best way to allow users to enter data in a multi-relational FMP database. I'm new to many-to-many relationships so will use the pupils/classes example quoted in the FileMaker manual, rather than boring you all with my industry-specific solution. Here goes ... I have a many-to-many relationship, with a pupils database connected to a classes database by a join file (because, as they note in the manual, many pupils can sign up to a single teaching class object, and a single class can in turn point to many pupils). However, when it comes to data entry in this solution, the teachers are less than ha…

Hmm.... I posted this question to the "Portals" section of this forum... but I think my problem may have something to do with relationships as well so i've copied/pasted my question below. Thanks for any help, or suggestions. ~me ---------- Is it possible to search through and/or sort records found in a portal? I have a portal that displays fifty lines of info... the way i have it setup right now is that, on each line, i have placed two fields that are read-in from another file called BillableX and TestsPerformedX, respectively. In the file that these fields are read-in from, I have fifty value-list-fields ("yes" or "no") that tell the user whether or not …

I am using FMP 5.5 on a G4 Mac running 10.2.6. I am a volunteer with my local county public school system. I have offered to help them set up a database that would show all 120 schools. The main purpose of this database is to track the textbooks being used in each class for each subject, including online contact information for publishers and individual textbooks (where it exists). This information will then be provided to the webmaster volunteers for each school's web site so that they can set up a page that has all classes/subjects listed for each grade level with textbook names, publisher contact information - especially links to sites for individual books that give on…

I'm working on a system with lots of files, relationships, etc. but am stuck on one interaction in particular. Parent file (People) and child file (Registrations) related by PersonID. Users can see related parent data from the child records, but searches on those parent fields are failing. For example, user wants to search for all Reg. records for person with last name "Kong" from a form layout showing data from People|PersonID::name_last. User knows there are plenty of "Kong" Reg. records, in fact they're looking at one right now, say. Result: No records found. User can go to People file and successfully search for last name = "Kong". But not from Reg. Any id…

I want to make a database filled with companies and their start and end dates. These companies have

hello, I distribute a database where the user installs the runtime database on the HD but leaves the large images-file on the CD-rom. At first run the user needs to locate the fmpro-fle on the CD to see the images, so far so good. Some users loose the link with the file on the CD (how can this happen?) or pick the wrong file. The relationship is now gone. How can I resolve this problem? (mac/pc)

Hi all, As there seems to be a trend for Calendar these days.... I'm half my way through my first calendar/planner which is the last peace for a Contact Manager solution. This solution will be dispatched to the Company subsidiaries. At the moment, the calendar allows "Company Settings" (different Holiday periods, Days offs, some subsidiaries would have Week-Ends closed, other Sunday and Monday,...), and "Employee Settings" (Holidays, Half-week job, 4/5 days work,...). Each day and preferences is scripted and indexed, suitable for ulterior relationships, so it's not an Infinite Calendar. One wish was to allow one user to schedule an appointment with anot…

I use FP on a Mac. When I open a database I would like it to open in a particular layout (of course it is an other one it opens in, the one I made first, thank you Murphy). How can I change in which layout it opens first? Thanks Eric

I

Hello everyone, I'm sorry if this is in the wrong section - I read them all and wasn't sure where to put this. Our Management wants to demo our program to another business. They won't allow installation of FM on their computer and I don't want to haul a computer there if I don't have to. Is it possible to install FMP6 onto a CD and run our demo from there? If so, how would I do it? Thank you for any suggestions, and please remember I'm pretty new to FM, so talk as to a newbie, okay? Thank you. Sorry, the other company has Windows but I'm not sure what version. Linda G DAC

Hi all. I'm having a problem pulling all the data out of some databases. I'd like to create one page that has all pertinent info. This is what I have (I'm only putting the fields that need relating in for simplicity) _____________ GROUP group_id user_id _____________ GROUP_ATTENDEES group_id attendee_id _____________ ATTENDEES attendee_id user_id _____________ USERS user_id _____________ What I'd like to do: pull data from USERS and place on GROUP that is related by attendee_id. HELP!! (please) Thanks! Lynn

I need a refresher. File A contains a list of student names and student ID numbers. File B contains teacher, class name and student ID fields and from file A I have inserted the student name field. The one to one relationship is based on the student ID number. There is a single record for every class taken and thus the students appear on numerous class lists. A new record is created by pasting in the students ID number and then selecting the teacher name and class. This works fine. File C is a form on which you record the progress of the students in each teacher's class. On the top of the form would be the teachers name and class and on the left hand side, usi…

Hello all. I have a question concerning relationships. I have not done too much with the whole relationship area of filemaker. I have a relationship that LeRetta help me setup. I have a layout with a calculation field from the other database on it. Is there any way that I can have it automaticly refresh. At this point it will one refresh if you click in the field or switch to a different layout or something. Considering it is a merge field the user won't be allowed into the field .......... any help would be appreciated Attached are the files ... the layout is "EnterStudents" and the field is "Info_Price" in the "DEV_Cadyware" file Desktop.zip

I was wondering if there was a standard term that most everyone uses for the following (or even if this is the most common way to handle the following): You need to create a relationship between two files where the match field in the master file needs to be the combination of two other fields in that master file. The match field in the related file is just one text field. For example: master::textfield1="foo" master::textfield2="bar" related::textfield1="foobar" I need a relationship (master::textfield1 + master::textfield2) --> related::textfield1. I almost always handle the above by creating a calculation field in the master file that is th…

I have two files, People and Agencies. Each Agency can "have" infinite People, each Person can "have" only one Agency. This means that the actual connection field is in People (Agencies.IDNumber is a field there). How can I count in Agencies how many People are connected to it? That is, in Agencies I have a portal that shows the staff members there, anyone who has that agency indicated in their own file. Zero or one or five or twenty. How do I get that number and use it in calculations?

I'm working on developing a point-of-sale and inventory tracking system for my church's reading room to handle all the inventory and sales. I've come across a few problems, and after searching the forum I was able to find my answer, so thanks to all. Now I've come to a hurdle, and I'm not sure of the best way to handle it. What I need to do is to get information from 2 files to display in a 3rd file, but these files don't have fields that make sense to relate. Let me describe my file setup, and I'll clarify the problem at the end. purchase (holds the basic information about a purchase, e.g. date, purchase total price) purchaseItem (holds all the line items on …

Am I safe using dates in 11/8/03 text format when using these dates as part of a key to relate to other files? Is it robust? I feel a bit uncomfortable about it, and wonder whether it would be better to convert it to a number (as FileMaker does when the field calculation result is set to Number.) Am I worrying needlessly? Thanks!

I decided I am probably overlooking something obvious so I will let somebody beat me over the head with it. I have 2 DBs PatientInfo and Chart Both have the patientindex in them. So I created a relationship between the 2 based on patientindex. Now I am trying to make a report that pulls the NAME from PatientInfo and specific items from Chart (lab results). Now I get the data from one db but not the other. They just won't hook up together. I think I'm losing it on "external field". Maybe I'm not setting that up correctly.

I have 2 DB'S (NEV and NEV_Vans)with a relationship established via the record ID. When I put a new record in NEV_Vans I want some of the data in the fields in NEV_Vans to appeare in NEV. I have dragged the fields from NEV_Vans into the NEV layout. Now when I make a new record in the NEV_Vans and put data into those fields, and I switch to NEV nothing is showing up in the fields in NEV even though there is data in the NEV_VANS DB. What am I doing wrong here? Thanks

I am new to FM and am porting (and redesigning) an access database and there is one functionality I am trying to duplicate. The main records file is called objections, it is a public consultation database. Related records come from files called Agents and Objectors. There are many to one relationships from each objector to each objection record. I want to be able to have a layout form for objections where the user can either look up an existing agent and/or objector and then this automatically fills in agent_name etc, or if that agent or objector has not been previously entered then to be able to create a new agent and/or objector. I could do this in …

Hi ! How would it be smartest to perform "New years change" in FileMaker db ? When year changes I would like to start serial numbering again from 1. I also would like to browse one year at the time. On the other hand it would be nice to be able to perform searches and statistics from all years in db. How have You solved this ? Arttu Lahdenper

Thank you all. I am a neophyte at Filemaker, so bear with me. Our client administrators must select the type of envelope to mail their client's materials out to shareholders. There are 6 categories of envelopes. Under each category is a further list. I have created a field entitled "Envelope" on a form. When they tab to that field, I want to have a list drop down with the main categories. When they highlight the one they want, then the list for that category drops down, just the way it works in the menu bar at the top of any Windows application. I think this is a relationship. I have created a separate data base with the the fields "Main Choice" and "Sub Choice" an…

I am new to Filemaker pro but I have a general understanding of DB development. I am using version 5 and I have a problem with a relationship between 2 db files. I have a form which was created for filling in some fields for a check request. The fields I have problems with relate to the company which is located in the other DB file called suppliers. I have defined the fields to use a dropdown box for the name and the remaining fields, address, state, zip, phone are automatically filled in with a look up. Now here is my problem. I made all the modifications on a local copy of the form Db file and everything works fine. Everything populates just like it is inten…

I've got a frightfully basic question...I've tried Help, the manual and searching the FAQs and other articles, but I'm still stumped. I'm trying to lookup data from one file (into another, the master (?!)) by defining a relationship between a master file and a related file. I've tried to define the relationship in the master where the relationship is determined by common field data, and made the lookup field in the master where the source is (theoretically) the related file. Nothing, however, appears in the lookup field though I know that there are matches between two files. I'm using the trial version of FP5 for Mac OSX. I've attached copies of 2 simple example file…

I have a script button inside the portal row. The aim is to open the related file and go to that particular record from that portal row I clicked. I just get to the first record in that open related file when I do so.

hi all, I have two unrelated databases named Product Type A, another one Product Type B. Via two joint files both of them have a relationship with a third dbase (Supplier - both many-to-many rel.) (jfType A Supplier, jfType B Supplier). How can I summarize both Product Type A and Product Type B so that I can view one field of both (one at a time) in ONE different database (Table view)? I have tried the following: I created a dbase named INTRO with the fields ProdType A ID (related to ProdType A ID of the first dbase) and ProdType B ID (related to ProdType B ID of the second dbase). In a third field of INTRO I defined the calculation: rlIntroProdTypeA::ProdT…

Hi I'm having a bit of trouble and wonder if it's a limitation of fm, or me I want to make a single database of pcs. the relationship I want to show is which machines rely on the current machine, and which machines the current machine relies on. e.g. 1. machine a 2. machine b (relies on a) 3. machine c (relies on 4. machine d (relies on a and when showing machine B I'd like to see that c and d rely on it when showing machine d I'd like to see it relies on a and b etc it works with a single reliance (e.g. 2 and 3), but when I set a multiple reliance (e.g. 4) it fails. I've set a relationship on field "relies on" to link to the "machine…

Hey All!, I hope this is the right forum for this topic... Currently I've got a relational DB used for time sheets/invoicing that's modeled after the sample that ships with FM. Employees enter their activity, room/equipment used and time spent on that activity which creates a line item record in a separate file via a portal. We bill for both the employee and the room/equipment used so I'm trying to figure out the best way to split each record in the line item DB into two individual records, one for the employee and one for the room/equipment. Any conceptual or practical advice on this topic will be greatly appreciated. Thanks...

Hi to all! I have an Invoices file in a DB system and what i need is to update an Accounts file each time an invoice is created for each record individually. Exp: If i create an invoice of "2 apples @ $2,00 each" for "George", this invoice should then be added to "George's" "Accounts" so i can keep track of his purchaes, balances, credits, etc. Could the records of invoices be automatically updated in the "accounts" for each individual customer? Thanks for any help...

I'm having a bit of a problem setting up database with dynamically calculating dates. Please bear with me while I try to explain my problem. I've got a Master file handling Job Information. This record will contain a Promise Date. I want to setup a portal where someone can create multiple unlimited Tasks for the Job and assign a length of time for that Task. That Task will then calculate a Start Date for that task by subtracting from the Promise Date. As a new Task is created it needs to calculate from the previous Task. The idea is to create a timeline report listing all of the Tasks and the days that they need to begin. Of course, as things change, they want to…

Hi All, I am fairly new to Filemaker - but not totally ignorant of database theory (though I feel pretty stupid at the moment) What I am trying to do is expand an exsisting relational filemaker database to include some new tables, namely I have a bunch of staff details, with their work details in another table. What I am trying to do is build an 'availability' table so a member of staff can phone up and say they can work on such and such a date and at such and such a time. So what I want to be able to do is add many records to my new availability table all based on one id_number field- which is obviously the same in both tables. When I try and insert the i…

ok i know that this post is here somewhere. but here i go... ok i need to create a relationship so i can just add or pull info for a value list. you know the like a "city" or "state" field. any help would be great. thank you, peter

How do I create a Projects / tasks system? (to weave on to our club db) The core requirements are to be able to create a new project with details, purpose and tasks. seems simple enough. However what do I need in order to delegate tasks to specific people (within the db) either as an individual or group assigned!?!? And lastly to be able to monitor their progress with a visual queue i.e. a bar that fills in based on their input when they update status of said tasks?!?! Note the only thing I

All, Can you please help: http://www.fmforums.com/threads/showflat.php?Cat=&Number=77332&page=0&view=collapsed&sb=5&o=186&fpart=1 Thanks Chris

Hi, I'm running FileMaker Pro 6, and I'm totally new to the software. We are using it in a retail environment. Currently, we have relationships defined, such as we enter something in the "Part #" field, and it puts data from that file into the "Description" field. My question is, would it be possible to define relationships in a multi-to-one format where I could type in the "Year", "Model/Size", and "Description" and have it fill in the "Part #" field from the inventory file without having to create another file for this process? I'm sorry if it's a silly question, I've been using this program for about 4 weeks. blakmac

FileMaker 5.5, Windows. I've done a lot of relations in a very complex set of tables, but this REALLY puzzles me. I have a simple table (X) of news items (id, headline, text) where the item can have several clasifications (eg to appear in lists A and B and D). So I hold the id and the classifications in a related table (Y). That way I can create a list file out of Y containing items repeated by each classification to use in a web-based MySQL database. Simple. Result is: Id class 1 A 1 B 1 D 2 A etc. To make this more useful I have a portal to the first table so I can see the headline: Id Headline class 1 text A 2 tex…

I am desperately trying to finish up a project before I quit my job next week and I keep getting errors saying that it cannot find the file ... which is a related file. It happens on different files and they are in the same subfolder. I called filemaker and they said that "the ideal way to run a related database is to have a dedicated server computer host the files and that all my problems would be solved" I have tried this on a trial basis, but still get the same errors. I am not using FM server. There are no more than 5 users sharing 8 databases. Usually only 2-3 are on at a time and in 3-4 of the databases. Does the order of opening the files matter, or am I jus…

I am working on a rental system where products are booked out at different rates depending on the calendar, which has no obvious start or end point. I have a rates file which contains the product ID, start date, end date and the rental value. These should not overlap for any one product, and there will always be at least one rate for each product. In a related file I'd like to be able to enter a start date and always return a rate. This rate should be either the rate for that product with the start date closest but less than my desired start date or, the earliest start rate if my start date was before the start date of the earliest rate. I've looked at Mikhail Edosh…

Hi all, Embarrassed to say I'm not exactly new to FM. I have been using it for 2 years and have cobbled together a couple of (flat)solutions. My (main) problem is that I still don't understand how to create a relationship. Maybe I don't understand the concept completely. I have bought books (and read them, too) but, still I'm confused. Now I really need to create some (relationships). When I try, following the examples in books, I get an error message that reads... "this relationship uses the name "blah-blah" in it's name choose another" or, when creating a lookup, ... "this field requires a unique number" , which is not true on this layout, but is on the layout …

Hi all, Assuming we have an unstored calculation in a related file, based upon a global in the Main file. Assuming we want to display these matches in a portal in the Main File. I've seen a lot of question about this, and ran myself in this kind of experiences. The best I could get at the moment, thanks to this Forum, is to : 1. use another unstored calculation of type c_ReturnId = Case(field = ::Main:global, Record_Id, "") 2. place it in a empty layout with only that field 3. perform a Copy All Records 4. paste the result in a global field in the Main file 5. Use a new relationship Main:Global::Related:Record_Id I was wondering if someone …

hi, i need your help with this: i need view a portal with date range, example: list.fp5--- date name money 20/7/2003 tere 100 20/7/2003 karla 200 21/7/2003 tere 100 22/7/2003 tere 150 portal.fp5--- daterange1, date daterange2, date relationship..... rel by date: portal.fp5 daterange1::list.fp5 date layout---- daterange1 ___________ daterange2 ____________ __________________________________________________________________ - ::date ::name ::money - ----…

We have: Property Companies People Each Property is owned by 1 or more Companies or People Each Company is owned by 1 or more Companies or People People are owned by nobody

(FMP 4.0v1 W98/Me) I start my FMP file. I am in a layout, with window maximized. I have a button on this layout directly linking to another layout (no script step). This other layout is a list of records, each with a picture. The first time I click this button, the second layout shrinks (as when you do a minimize script step). It takes a few seconds for my Model T Ford computer to load all these images. But then, when later on I reuse the same button, the layout with all the records appears without shrinking, and quite fast. Could someone explain, please?

I have a calc. field which I'm basing a selfjoin portal with relationship fields to be listed. So, any time that calc. field is altered the list of related records should be altered too. But I get "This relationship will not work because the field "..." cannot be indexed." I can think about a script to set the relationship field, but how tedious? It would be nice if it coul be based upon a calc. field somehow.

i am setting up a contact, reservations, and donations database for a local theater. i am stuck on the letter/email part of this. mass letters/emails will need to be sent based on various search criteria (group, name of last show, etc.). doing the search to create a found set is not the problem. with that found set, i do not know the best way to go about the letter database. i know how to simply create the letter with the found set, but i need that letter to have other custom fields inline with the body of the letter so the letter seems personalized. i also need the letter date field to automatically enter itself into the main contact database in a field that tracks all c…

I have a staff database (1 record per person) with a relationship to their actual work positions (many records per person). This database has a relationship ( ne record per location) to a school database for the work location and data about that location (ie address phone numbers etc). My question is can I view address and phone number data from the staff database via a relationship from the school database? If no is this a limitation of filemaker to only do one level of relationships (ie a star pattern of databases)? I'm using FM 5.5 on windows.

FMP 4.0v1 W98 I have 2 files, and a defined relationship between the two using one key field. The relationship works as expected between the 2 files. Great! The problem: I selected in the "Edit" of the "Define relationships" for my master file "Allow creation of related records". But this does not work... In this forum, someone posted a very similar question a while ago (02/25/01), and a bad guy answered: "Hi, bevin Nothing will happen in your other 4 databases until you either create a related file via a portal or script. Relationships provide a means of making data available in one file available in another, but do not by themselves create records. R…

Hello Gang! I am still hopeing that http://wmotion.com/visualizer.html willl be out for windows platform...does anyone knows of ANY visual tools for FM? oh why oh why FM never got the concept of tables vs. files Thank you!

Hi. My lookup used to work fine, but now it fails most of the time. It's designed so that when you input a song title, it tells you what album that song is on. FM 5.0v3 Mac OS 9.1 Match field in master file is a repeating text field with song titles. Match field in related file is a large non-repeating text field containing track listings of entire albums. When a new entry in the *song title* field matches anything in the *track listing* field of the related file, the *album title* in the related file is copied over to the *album title* field in the master file. For some reason, this doesn't always work. When the *track listing* field of the re…

Hey All, I'm sortof new to FileMaker so please bear wtih me... is it possible to define a Relation to another Relation? If so, how? For example: 1.InvoiceList-file is a table that holds certain ID#s (Invoice Numbers) and their respective CompanyNames. 2.ContactList-file is a DB that holds all the CompanyNames and their respective information(addresses, etc.) 3.InvoiceInfo-file is a DB that basically holds a report(s) that should read in information from both files 1 and 2. In InvoiceInfo, I can choose a certain ID# using a value-list that reads-in all the ID#s from InvoiceList. Once I choose the ID#, I have it so that the respective CompanyName…

I have 2 DB's that contain info about customers, conveyors, widths, lengths, thicknesses ect. DB1 has ALL the above mentioned fields. With DB2 i want to be enter values into the Customer and Conveyor FIELDS only, and IF there is a EXACT MATCH of the CUSTOMER & CONVEYOR fields in DB1, then rather than having to enter all the other field values into DB2, i want the Values to be taken from DB1 and AUTOMATICALLY placed into the correcsponding fields in DB2. EG. DB1: customer=fred conveyor=C100 length =100 Mtrs width =1200 mm thick =10 mm DB2: customer=fred conveyor=C100 length = width = thick = Afte…

Hi All, I have the following files MainStart, InvoiceHeader, InvoiceLines. Right now InvoiceHeader & Lines are related by invoice#. Both Header & Lines have a constant link (value of 1) with StartMain. StartMain holds name labels for various buttons and layout titles. The idea was to have the menu items switch languages base on a field in StartMain. All works fine....except that i now realize that in a multi-user setting each user will be "stuck" with the same language choice. Could i move StartMain to each computer (kind of a front-end) and can all of the StartMains link to the Header & lines dbs?? What/How does FM work in multi-us…

I have tried several several attempts at building a schedule relationally based on specific criteria and hope you guys can offer some possible methods. I have a file called contest with data in a field called school and a layout with several choices like start/end time, lunch break, limit per school per room, etc. Here are the two main criteria: a school has a limited number of participants per room (say 10) and it cannot perform at the same time in different rooms (school A performs at 8:30 in room 1, but cannot perform at 8:30 in room 2). So say we have 100 entries and three schools with numbers 50, 30, and 20. If our contest is 8:30-5:30 with an hour break, there are 6…

Post deleted by TitanJeff

Is there a way to get a copy of a field's index as a list? I have a DB that collects input off the web. Often, I have several entries from the same person. I would like to use the index of one of the fields (actually a concatenation of last name and email address called "ID_Code") to create a related Parent file with only one record per "customer." In other words, I would end up with a parent file in which each customer's record would have a portal to view all the transactions listed in the original DB for that customer. I was thinking that this would be easy to do -- I would just create a new database out of the index of the ID_Code field -- but I can't figure out …

Kind of new at this. I've got three DBs I want to create for IT asset management. DB1 Hardware - Has user data, serial number, and the standard software image that is ghosted on to the machine. DB2 Software Image - This database has the actual software contained on the software image mentioned in the previous DB. The software fields are simply radio buttons, so whoever sets up a new image can just click them on or off. DB3 Software Database - This is the one that tells me what software is set on what machine. I want to track software by serial number since a user can have more than one machine. It looks a lot like the image record design, but also look…

I need to create different registration forms for different classes, after I type in the name, I hope that the database will search for the participant information and fill in the information in the registration form automatically. I wonder how to define the relationships for this. Thanks a lot.

Please tell me if this is possible. Ok quick run down: Horse.fp5 Name (text) A Portal (portal of info) Displays (Horse Tasks.fp5::Name, Date, Task, and Notes) Horse Tasks.fp5 Name (text) Task (text) Date (date) Notes (text) Now, lets say that someone changes the name in Horse.fp5 (which is the relationship between the files). Now all the info disappears from the portal. I know the reason why is because the records from Horse Tasks.fp5 is still the old name and the file Horse.fp5 has a different name. I need to know if there is a way and how to execute changing the name of the records in Horse Task.fp5 wh…

hi all, i've made a many-to-many db by creating a join file for two base tables/files (they use unique ID's for records which are joined in the join file - i'm a newby and this is textbook). When i change some data in one of the base tables, my join file isn't updated. So a portal in the other base-file isn't updated as well. As this is fundamental for relational db's i must be doing something completely 'n uterly wrong (or the FileMaker company is ...). Ideas anyone?

I am trying to use a calculation field (currently no stored, but tried both ways) as one end of a relationship with a second database. The relationship is on a unique ID to populate the portal. The calculation field works fine and constantly changes as you click onm different records in a repeating field. The problem is that the relationship does not seem to work as the field in the portal does not change to follow the calculation field. Any ideas???

I have a relational db with a couple of db's USER and LOAN. The LOAN db holds term, and monthly payment amounts. What I want to do is create a third db called LOANPAYMENTS that will hold individual "invoice" records for each monthly payment for each user, so that I can forecast collections by month. I could do this manually of course, but I'm sure this is not a new issue. :-) Ideally, once I enter a new record in LOANS, I could write a script that creates X number of records in PAYMENTS, where X equals "term" in LOANS. Loans db also has month of first payment, so script would then also use that value as due date for first payment record, then add a calendar mon…

Background info. I have four levels of grouping. level 1 and level 4 are always present. level 2 and 3 are sometimes present. data looks something like this (all in one table-can't change it..."supernormalized sort of") TABLE ( UBBcode code doesn't work for me excuse the ".'s") id.....level...parent_id....data 1......1.........0..................Q group 2......1.........0..................A and B group 3......2.........2..................A subgroup 4......3.........3..................asdf subsubgroup 5......2.........2..................B subgroup 93....4.........1..................qwerty 94....4.........4..................asdf1 95....4…

I know there's probably a simple way to do this but I can't seem to figure it out. When viewing the date field through a portal, the dates of the entries (very important in my case)show up in the order by which they were entered, not in the descending order I want them to show up in. Even if I sort the source file, the result stays the same in the portal. How do I get the files I'm viewing in the portal to sort in an ascending or descending view? Thanks.

I am making an inventory for the Boy Scouts. We have the database all drawn out, but I have run into a problem: I need to have a general index of all items. Every item is either serializable (which means we have a record of each item, like Helmets, where each helmet has specific information stored about it), or not (like Caribeeners, where we would store more generic information like how many on hand, price per unit, etc.). I have a file for serialized records, and one for non-serialized records. Then I have a file for the master list, which only has fields for serial #, name, and part ID (the part ID is unique for all the items, whether it has a serial or not. That …

I'm a newbie, so I apologize in advance for my lack of knowledge. I have two files, EligibilityYearly.fp5 and Main.fp5. In EligibilityYearly.fp5, the data entry fields are : Plan No. Year Provider Member Classification Eligibility Count. I created one layout in EligibilityYearly.fp5 that totals the eligibility count by provider, and another layout by member class when the user finds the plan no. and the year. Both also show a grand total of the count for the plan. My problem is that I would like to display these summary reports in Main.fp5, which contains no records. I tried to relate the two databases using a concatenated match field …

Hi. I want to create a db system that consists of a

Hi Folks, I've been using a series of "single to many relationships" to produce a way of navigating around a large database. It takes the form of a single record having any number of "children" (which you can navigate to by clicking on). It's been really successful but I now need to reverse engineer this to a point where a record can have A NUMBER (not just a single) number of "parents" The coolest way of doing this would be with some kind of many to many relationship .... but I'm really not sure if this is possible? Can anybody help? Best Giles

I'm creating a database to track donations to a charitable organization. Frequently multiple donations are made by the same individuals. What I need to show is an ongoing history of donations made by the same parties. Is there a simpler solution than a relationship file/portal? What I'd like for the user to see is the following: I'll have them do a find on a first and last name and if the donor already exists, the file information will be produced. If not, the data will be enetered. Each first and last name is linked to a unique id.(this part is already built) The organization needs to see how many donations each individual has made and that is what I want displayed on th…

For relationships (self and otherwise) do you think Sum( rel::constant ) or Count( rel::constant) would be faster, given that constant = 1? I'd like to shave off some time when validating uniqueness of records in a script, i.e. If [sum( self_client::constant ) > 1] vs If [Count( self_client::constant ) > 1] Or do you think the difference is probably negligible?

I used to work with Filemaker all the time, but haven't in quite a few years, so I'm a little (okay, a LOT) rusty. If there is an answer to this question that can be found by doing a "search," please let me know (but I did try that first, and was quickly overwhelmed....) Anyway... I have a fairly simple database project set up for a small retail business. They have three files: inventory, sales receipts, and customers. We want to use the customer's telephone number as the look-up for the inventory and sales receipts databases (using the customers database as the value list). For an existing customer, when you type in the telephone number, it will populate the…

Hi ! I have a problem with creating a report where there is in the first file persons (Person1, person2 with different activities (act1,act2 etc.) In a second file there are same persons and different activities (act3, act4) Now I would need a report with amount of activity per person from these two files: Person1........act1.........Count_of_act1 ...............act2.........Count_of _act2 Person2........act1.........Count_of_act1 ...............act2.........Count_of_act2 etc How to do this ?? Thanks in advance Arttu

Hello, I'm trying to create a useable FMP database solution for my lighting company that rents equipment. Of all the FMP inventory solutions I've seen, they all deal with sales inventory. Does anybody have any suggestions for creating a comprehensive rental solution? Specifically, I'd like to have a solution that allows a user to enter numerous items (equipment items) into an order for a customer, set a Rental Begin Date (items leave our inventory) and a Rental End Date (items are to be returned), as well as an order status category (e.g. "quote", "reserved", "out", "returned".) The user would have a button that could search for the availability of all items in…

Hey list! I have two files that relate to each by a unique calculation. As many of these as I have done, I can't figure out the reason the following is occurring: Both use a calculation to establish a unique ID and to related to each other, example: My Title9351 (combining a title text field, a three digit event code, 935, and class, the last digit. So in my list database I have hundreds of these that work great except this title: 20. Shady Grove (from Two-Part American Songs, Book 2)9331 20. Shady Grove (from Two-Part American Songs, Book 2)9351 both still have a unique ID separated b/t the 3 and 5. In my entry database, when I choose the second one…

New User! I've read that FMP cannot do a one to many with a subsequent one to many but that there is a workaround. Could someone guide me to such a work around? For example, one street has many house numbers and one house number has (may have) many families (though usually not at the same time). One CD has many tracks and one track has many artists. I know in this latter case you can use many to many. :confused: