Relationships

Ok, I'm stumped with this. I know I'm not thinking about this the correct way. So I'm asking for help. Situation: Main database: portal1 --> contact database, portal2 --> phone log database What I want to do is have the user click a button in portal1 to record phone call information. The button should actually create a record in the phone log database. I'm creating the phone log functionality right now and this is where I'm stuck. the main database has a relationship to the contact database via a field in both called recordID. I'm willing to setup any type of relationship to the phone log database. Any help is greatly appreciated. Paul

I'm new to Filemaker and working on a little project and I'm just curious if there's a better way to do what I want than what I have in mind. What I want is to populate 2 databases from a single Web interface with a shared key. The key is actually comprised of 3 data fields concatenated (together, the first 20 Characters will always be unique) What I was thinking was, I'd get those three fields along with the rest of the initial data, and then post it to both databases via CDML.. only.. I'm not sure I can do that? Perhaps I could specify the second in an inline action? Or should I store the data input as tokens and push it to a second post? Okay, perhaps so…

Hi all - I've been searching around this and a few other sites and although there are some good tips and techniques here - I am still having a problem creating the following: I have a main database that has blank fields: town, county, state, country. In a second database I have filled in fields: town, county, state, country. In this second db there is only one instance of each town, but many towns in counties, etc. I want to type the name of the town in the main database and have the county, state, country automatically pop up in the corresponding fields. I know this is possible but I have been trying with no success...the closest I got was returned with an error mes…

Well Hello Everyone, great to meet you.. Ok, well Ive been searching and lurking for a few days now, and am totally confused.. I did search, but , ahem... still don't get it.. Im sure their is plenty of info here, but cant find the answer.. Well here we go...I've got 2 databases... the first one is telephone.fp5 the second one is invoice.fp5 Telephone database walks the office gal through a step by step script of how to answer the telephone, and print an estimate, hang up, etc. Sounds dumb, but this way everyone answers the phone the same way. Three types of estimates are available. Trees Stone Lawns If the customer wants a …

I am somewhat experienced with FM but not so much with the relationship feature. Here is my ambition: I am using the Filemaker Pro MEETING template/solution and have just begun to use the FM TASK solution as well. The two, however, appear to be redundant in creating TASKS (in Tasks) and ACTION ITEMS (in Meeting). Is there a way to effetively merge these tow so when I create an action item in MEETING I can then see it and work on it in TASK. and visa versa? Thanks for any assistance. Dave

I have a relationship between two databases. One getting information from the other for auto entry on new form. FM takes information off the oldest matching record on auto entry. How can I make it automatically get the information from the latest matching record? Thanks! Brent Vinton

What are they? Unique id? What is a left hand key, a right hand key? Where are my keys? Any advise would be great.

OK Im building a my first database in filemaker for a new project at work. Basically we are doing preservation work with audio recordings. The datbase is broken into four different tables (files). Two of these files are the original item file and a service copy file. There can be multiple original items on service copys. the main entry file is the original item file, and i would like to be able to edit service copy information from it. Right now I have a service copy view with a service id that links to the service file in my original item file. I can pull up the records in the service file, but i dont seem to be able to create new records. I should clarify, I …

how can I, based on a field in a current record, open another database to a record based on the field from the original database example: I have a field called "systemid" in database1, and there is a field called "recordid" in database2, how can I, from database1, open database2 to where database2.recordid = database1.systemid?

*NOTE* I HAVE NOW INCLUDED A FEW FILES FOR EXAMPLE - please help! i have a database where each record is a specific cost code and i use these records to fill a value list in my main file. also in my main file, is a summary log where i would like to print out every cost code as well as a calculation. the calculation i need to calculate is the following: "the total amount of hours spent on each cost code in all (found) records" i am able to do this with a simple Case statement that checks the "cost_codeX" fields, the only problem i have is relating these fields to the actual cost codes in the other file, i tried using a portal but i did not accomplish …

Congratualtions to the developer of the smart ranges concept. We also got it working. Now i think i have a misunderstanding. Suppose i want to find records that have a starting date of 1 may 2004 and end date 5 may 2004. With our current multikey approach we also find records with periode 3 may 2004 until 10 may 2004 and records with period 15 april 2004 until 43 may 2004. Actually i only want to find records with a starting date before 1 may AND end date after 5 may. Okay, i can use a caluclation field. But is their a solution in the multikey itself. Suggestions are welcome Thanks Jitse

I have two files, one called People, another called Notes. What I need is for there to be many Notes records for one People record, but I can't seem to figure that one out... I have created one relationship from the People to the Notes with the "create related records" box checked, but it isn't letting me create many Notes records attached to one People record. I have several fields in the Notes file which are looked-up from the People file, for which I created a second relationship - is that where I went wrong? Or am I missing something really simple here? Thanks in advance Charly

Hi I've heard that I shouldn't create many relationships using the same key (client number)... I'm building a database at the moment which would become rather annoying if I had to use several different serial numbers for each relationship - so was I told something silly? Thanks in advance Charly

Hi I

Hello People! I couldn't decide where to post this but my concern is definetly about the relationship. Thanx to Chris and Ugo I managed to create a file for "managing" my categories -> to be used in a value list (in other related file). All is great and functioning, but my concern is: "how stable" are the relationships? The idea was to create a GUI that is easier to follow and understand, I am aware that I can not use these relationships in process of "adding"... File is attached, so those of your have expreince with catgories file & management please let me know what you think....perhaps I should have posted in Sample form... anyhow, thanx for the…

ok hey i dont no anything about relationshops cud sum1 plz make my database so it gets the pricees from price.fp5 and puts them into paul.fp5 into the quote layout thanks Archive.zip

As usual, this has likely been explained (several times??) but I can't figure what or how to search to find the answer. I have 3 files -- Students, Clubs, ActiveYears. In Students, I have a constant::constant relationship with clubs which gives me a list of all clubs. Now I want to select a club from the list and have 1) the club details (address, etc) show (from Clubs) and 2) the club roster (I have a relationship between Students and Clubs (matchForClubName where _gMatchClubName (global text field in Students) is related to MatchClubName (text field in Club). then I want to select a name from the club roster and have the student details show (from ContactInf…

Hi. Would appreciate some help with the following: I have two files Days and Dates to form a simple diary for clinic appointments. Dates is shown through a portal on Days. (Seems to work well!) I also have a Customer file. I need to get the customer ID and customer name through to the dates lines in the Portal so that when I enter the ID the customer name comes up. I can do this in the Dates file itself, but when I put the fields on to the dates portal, the name doesn't show automatically.What am I doing wrong? Many thanks, Roger

Im working on a solution that when a job is in the shipping department they can push a button and add a box number and description for the box. I would like it to number the boxes automatically and start over at #1 for the next order. I have been working with a relationship that works on the work order # but I can only seem to view the 1st record or box from the shipping screen. I can however see all the boxes if I use a repeating panel. I would like to do this without the panel and when I click "add new Box" have the info in the fields clear so that I can add another box. Does anyone have any Ideas?

In Average,Count,Extend,Getrepition,Max,Min,NPV,STDEV,Sum or GetSummary an expression was found where a field alone is needed. I tried to use other fields and I get a message The Field can not be Found. I'm trying to calculate a total for a relational record. A portal total summary. Anyone can you help me? Frank Platform: Mac G3 / Version: OS X 2.6 FileMaker Version: Pro 6 Platform: / Version: FileMaker Version:

I am building a relational database. One of the databases contains pictures in a container field. I want to also display these pictures within the layouts of the master file. Given that container fields are not 'relatable', how is this possible. Any suggestions would be most appreciated. thanks! fielding

i have a document that has several date related child documents, using a doc id as a key, the parent document is created say on the 10th, child documents are created on the 11th and 12th, i would like to make a report of the parent document, and all documents on a given date, say the 12th..., but not all the child documents. how do i do this, its driving me nuts!

I'm developing a solution with a one-record viewer file. There is a twenty-six-record file called Service.fp5 which lists 26 different categories, with serial numbers 1 through 26. These services need to be field labels in the viewer file. Is there any way that I can do this without setting up 26 different relationships? I tried calc fields of GetRepetition(Service__constant1::serviceName, 1) all the way up to 26, but that only works on repeating fields, not related fields. The client wants a static multi-columned table to be shown at the bottom of several layouts, that uses these labels, so I can't do it in a related file or a portal. I would really like to hav…

Hi all In a database describing processes, tasks and who does them (roles) I have several tables: A has a unique number for each task It also has a portal showing the individual or group role (which is stored in : B has the task unique number, and the stored value for the individual/group. When a new task is created in A, one record is created in B for each selected role. B also has a portal showing the 'actual role' which is stored in C. C has two relevant fields, and is the way in which the names of those individuals who make up the group can be revealed. The fields are Role/Group and Actual Role. When the individual is named in their own right, not as …

I have a set of related FMP 5.5 databases for billing. They include a "Line Items" file that picks out the appropriate price for a product from a related 'Products' file based on a case calculation (each product has three possible prices.) This works great, except when prices need to be adjusted. I need to be able to change the prices (for future records) without affecting the prices on old line items. I think I'm missing a key concept in the way these files are related. Any suggestions for how to fix this would be most welcome. Thanks.

hello all, im a newbie at all of this and am trying to develop a product catalogue sales invoice system for a jewelry store/gallery. i have 3 files, contacts, products and sales. contacts and products are working fine, but i am having problems with sales. What i am attempting to do is: locate product you wish to sell in catalogue (identified by id number) then hit a button "sell this item" which opens the sales file, creates a new record, and pull in the id number from the catalogue files current record and use this as the key for the relationships for the other fields. is there some kind of pass variable option in scripting so i can automate the creation of a new …

G'day All I'm not sure if this post goes here or in the define fields section, I have a booking database that relies on the concatenation of three fields to create a unique key (timeslot) for each booking which is "time"&"room"&"date" On my booking page I have created global fields for time, room and date to temporarily hold the information while I check if this timeslot is available. What is the best way check if the timeslot is full or unavailable? I'm doing it this way because I don't want to create a new record first and then do something like this: If count(SelfJoin:key)>1 then don't book. I had this working but it was confusing for u…

Hi. How do I compare a value in my current record, to its value (in the same field) in a previous record? For example, I want to compare the current price of an item to its price 12 records ago. Thanks. -Emery

Hey everyone, I am a mere babe in the woods here and I am trying to create a relationship between just two databases. I've read the tutorial, but its not working. Also I'm trying to digitize some audio recordings to correspond with this linked database. I worked previously with a similiar set up and used montage to capture the audio, but in trying to replicate this set-up and failing miserably. Any ideas? Thanks.

Does anyone know of a simple tutorial for relational databases and lookups? I'm still a novice with FileMaker, though I'm doing all right. But I'm trying to set up relational databases, and I'm hopelessly lost. I've read that section in the User's Guide three times and I'm missing something. I'm wondering if there's a step-by-step guide on doing this. For reference, here is what I'm doing (and it's not very complex) Database 1: A list of sponsors (name, address, phone, email, etc.). Simple. Like a contact list Database 2: A list of events, containing date, description, donation amount, and sponsor name I'm creating a layout in Database 2, and when I en…

Hello, I'm a little shy about asking, I'm new to this so please be patient with me. Okay, I made a small database to manage our little business (movie rentals). I have two files, one with our movie inventory and one with our client (members) list. I would like to know how to create a historical of the movies our clients have rented. Right now, when a client rents a movie I made a simple script that fills the records of date of rent and 'rent due', it also shows me who's renting in the movie inventory (I made a relationship to bring the info of the client from the client file to the movie file). But I have no idea where and how to store what movies have every client r…

Hello - I am trying to set up a database involving 3 files keeping track of CDs released during the year: 1. Releases (e.g. artist/title/format/label) 2. Artists 3. Labels What I would like to do is be able to enter the information concerning each CD in the Releases file, and have that create (as necessary) new Artists or new Labels as they arise. However, I haven't found a way to be able to have the existing Artists and Labels show up on the Releases layout without also creating duplicate records for Artists and Labels who appear more than once. I tried formatting the fields for the portal records to have a Value Field equal to the indexed contents in …

Hi, I am trying to add on to my current invoicing solution. Right now I have 4 main files that enter act with this invoicing solution: [*]Customer.fp5 [*]Sales.fp5 (holds the invoice records) [*]LineItems.fp5 (items added to the invoice) [*]Inventory.fp5 (looksup item prices and descriptions when a stock number is entered into a lineitem filed of the invoice.) Problem We sometimes give special pricing, on some items, to certain customers. So the only way for an employee to know if this customer has a different price for this item is to look at past invoices. Scan through them looking for that item and the price on the invoice. As you can see, …

Hello, this is my first post! I've got a three related databases. One has names. One has jobs. Many people do multiple jobs so there is also a relate DB that joins the information from the two. When the user enters a name in the relate DB, there is a lookup that fills in other data about the person. However, I'm constantly having to check whether a person is in the DB (and if not, add their name) beforehand or the required information would be looked up. So, what I'd like to do is this: when I type a name in the "relate" DB, it will check the name DB. If the name is not present, it will add it and fill in the lookup information. There is an option for "Allo…

I am having great difficulty creating a working relationship between my InvLineItems and Invoice files as I have a unique set of fields that I am working with. I ship various products via truck from various suppliers and it is all organized via my "Orders" file. As the load is shipped, I enter the shipped weight in "Orders" and a "InvoiceLineItems" record is created. I need to get the info from InvLineItems to my Invoice. My "InvoiceLineItems" entries are created from my Orders file via a relationship defined through a "ShipSerial" field that is unique to each order. My "InvoiceLineItems" has the following pertinent fields: ShipSerial (key in InvLineItems…

Our files are getting too large. It takes forever to search and much of it isn't necessary anymore. But sometimes we need to view old data so it must be available. What I would like: A layout which contains radio button list of years that will display that archived file in a portal - or even take me to that database. Our Promotions need to be split into several files by year. File currently has 930,000 records. How can I display the year selected in a portal if they come from different files? I want each year in a new file and I want to somehow automate it so that it's easy when I split off a year to have it displayed on the layout as a radio selection. How d…

Hello, I

It seems like it should be easy, but it is not working. I have a complex database with all kinds of information. The related file contains only "First Name" "Last Name" "Full Name" and a container file for a photo. "Full Name" is the matching file as it would be the same in both databases. It is simply (in the main DB) First Name & Last Name. (In the related DB it is a text file.) In the relationship definition it is set to "Allow creation of related records" as well as allow deletions. So when I create a record in the main database, shouldn't it create one in the related DB? It does not. However, delete does remove the record from both files. I must be m…

I'm trying to summarize the data from a multi-record per relationship file into a single field in a destination file. I'm using a calculation field in the destination file, but it only finds data in the first related record. WTUCountyWorking.fp5 has these fields (plus others not used in the calculation): SymbolKey (used to define relationship) State County Data in the State field is either "Washington" or "Oregon" and the County field contains the name of one of the 75 counties in the two states. There are anywhere from one to 40 records which have the same value in SymbolKey and more than 16,000 records in the file, which came from an outside so…

Can someone point me in the right direction for this. I have a database with 562 records in it and I want to enable the web companion so that people can log in from a web browser and see only about 23 of those records in form view. The 23 records that I want them to be able to see are for a winter tour coming up. I only want them to be able to see them as a report and not be able to search or enter any data (I can figure that part out). I can create a flag field for marking the records that I want displayed but I am not sure where to go from there. I also want the number of records shown to be dynamic based on whether or not I flag them. It seems to me that the best …

Hi Guys! I am a total newbie and this is my first post here I still work on my Invoice db and now have a new problem: In my Invoice I have a Value List for different Currencys ie. "

Hello, I've just returned to using Filemaker, so my knowledge is a little dusty. I have a file storing data about all of the companies we deal with. Within a layout, I have a portal listing all employees of the company. I also have a button to create a new employee in that company. The employees are related to the company using a company ID code. In the past, I have had a script which copies the company ID code, opens the Employee file, and runs a script in the Employee file which pastes the company ID. I now know this is bad practice. It did seem a little inelegant. I have been told that you should use global fields. I assume that you are suppos…

sorry for being a scripting lightweight but here goes... I have 2 databases. one for actors and the other for jobs. both files have a field called 'job numbers'. I set up a relationship so both files share 'job numbers'. (I hope I did it right) in the job db I've created a layout that has fields on top and bottom and is set up the way I want it. in the center of this layout I'd like to be able to list all of the actors (from the actor db) which have a matching job number. I cannot figure out how to do this. I created a button that when pressed triggers a script that essentially says if actors::job code = job code SetField ["first name", "acto…

Hello, this is my first project using FileMaker so I am facing various beginner's difficulties. One of the is following: I want to record vehicle activities at Entrance/Gate. I created a file Employee_Info where I stored basic info for each employee (Decal, Name, Vehicle Type, Vehicle Tag) I also created Employee_IN file/form, where user types a Decal and after hitting Tab all other information (from Employee_Info)about that particular employee fills out autamatically. Additionaly Day and Time IN gets populated. This works great. I also have a file Employee_OUT which records day and time an employee left the company gate. I created a relationship between Employee_…

Hi All, I recently posted a question about multi-user & multi-language issues. With the help of Ernst i got it working. One last thing to solve/fix with all the calculated fields (used as buttons or field labels) when i go into FIND mode they all go blank!! What can i do not to have this happen? Why is it happening? I end up with layouts that are in NO language instead of French or English!! Thanks --Dan

Hello, I was wondering if someone can help. I am creating two databases, one is call Daily Inquiries and the other one is call Funding. I want to create the same nformation that get created in Daily Inquiries to Funding. Each databases has the id which i create, call ClassID to connect them. Any help would be really appreciate it. Thanks, Victor

So here's my dilemna/question... I have a fairly large database-solution made up of about twenty different files. I am required to rename one of the files (a contact list from which a lot of the other files pull info off of) to something else... will this mess up all my relationships that i've defined in all my other files? I think the answer is yes. Is there any way that I can change the name of this file and have that change "recognized" in every other file in the database where this particular file is used? Some sort of utility that'll take care of everything for me, perhaps? I'd appreciate some info on this subject. I really DON'T want to have to go in…

how would i go about setting up a system where users could type in a code from a given list (a list of about 100) and enter data pertaining to the code (a time card). i would then like to track how many hours have been allocated to each code. could anyone provide some insight please?

I am trying to do a lookup using a seperate FMP file. I want to be able to lookup cities in alphabetical order. I would like to enter the "city" field and have a list to choose from, "city list".. I create the relationship from "city" in file 1 to "city" in file 2. I then select "auto enter" in the "options for field" I specify the following: relationship is selected (its the only one) it states the correct match I select city in the "child" field When I click ok, I get - This lookup uses the field "city" in its definition. Choose another field I have used differnt names and I get the same response. What am I doing wrong. I do not want to u…

Hi there, I finally gave up and decide to get some help...humm...doesn't sound healthy, but anyway. I am working on a database for one of our programs(3 sub programs). They want to keep track of expenses. I am using fp5. and I have everything set up, but I haven't (can't)figured out to keep 3 different sub programs from viewing every one elses infomations. Help

Hi all, I'm basically new to Filemaker although I have attended a couple of courses. Anyway I have to review a database with the view of revamping it into a relational DB. I'm OK with relational DB concepts, and am busily researching implementing them in FM Pro 4.1 Can anyone direct me to good clear resources to help me get started? Especially in regard to the issues associated with relational BDs in FM Pro. Also how do I set up a database so that more than one user can access it at a time. Many Thanks

I'm trying to define a lookup using two criteria, but "...when the same value exists in the match field in more than one record of the related file, FMP copies the value from only the first related record [ie based on the first criterion only?]." Our oh-so-useful manual goes on to say that "The first related record that's accessed depends on whether the related records are sorted.." Surely there's a way around this limitation? Or am I missing some obvious means of doing this? Here's a more detailed description of what I'm trying to achieve and what (I think) is my problem: I have two databases. The first consists of multiple records, each containing data on the …

I have a system I use to track all the databases used in the company. In this I have a to do list. Each to-do has a check box for done. I want to be able to do a quick find for record that have un-done to-dos. I tried making value list on a relation "toDoList_x" in a calc field like this: Note: with my check boxes, on is "X" If( PatternCount(ValueListItems(Status(CurrentFileName), "toDolist_x"), "X") < Count(GL Database | zk.systemID_p # zk.systemID_f::zk.databaseID_p) , "0" , "1" ) the idea was to then do a find on that field. Though, as it turns out, the value list based on related values filters out duplicates. So it does work if i…

Hi there folks - I'm hoping this is an easy one, and I'm sure it must have been asked before but I'm buggered if I can find the answer. I have two databases - hardware.fp5 & users.fp5. "hardware" contains information about the computers in my section and has the following fields : ip (= ip number) compname (= computer name) dnsname serial "users" contains information about the users in my section and has these fields : fname sname id comment (Computers can have more than one user, and users can have more than one computer). I can successfully create a relationship between the two files based on the compname field so that if I enter …

Hi. Is there a way to do a find that displays the last x number of records? For example, I only want to find only the last 12 records in a database (records 29-40 in a 40 record file, for example). Also, I need to copy the contents of one field in each of these 12 found records to 12 corresponding fields in a single record of another database. So for example, say there is a field called "name" in the original database. In the second database, I create 12 fields called "name1, name2, name3, etc. Then, I need to import the names from the 12 found records into these 12 fields. So the value from the "name" field in first found record of the original database would be cop…

I've got myself in a muddle.. With two databases in a simple relationship. (story of my life ;-) SAY: when I create a new record of a pupils attendance. Pupil.fp5 global.fp5 attend.fp5 (with pupil joinID) I have global fields (in a separate global.fp5) like times and dates, on a layout of the pupil.fp5 database. Then a script in attend.fp5 creates a new attendance record and copies the global details with the pupilID. And a portal on the pupil.fp5 layout shows the new addition. I don't know if that's the best way of doing it? But it has created a problem. When several people are on the network (running off FMP server) people can't add data togethe…

Okay, so...it's possible that i can't even do what I'm trying to do or that this isn't the appropriate way to do it, but some help would be appreciated. I play a game called HeroClix. One of the things you need to do in this game is assemble armies of little figures within certain constraints. So my goal is to create a database with two primary functions: cataloging my particular collection of figures and their relevant statistics, and then using that list to compose armies. So my thinking was to create two databases, one for each primary function, and use relationships between the two of them to accomplish the goal. So far I haven't been able to get it to work.…

Strangest thing. I have a related field (not in a portal). I can change the font, but I can't get the size of text in the field to change. No matter what font I pick, it always stays at 10pt. I dont seem to have trouble changing the point size in similar related text fields, just this one. It has me baffled. Anyone come across anything like this before? LR

folks, we have two dbs: source.db & target.db. we need to kinda copy records manually from source to target by using a button. how can we do that? details on that: source.db has lots of records. we want to be able to select one (no problem for us) and put it over to target.db (problem for us). idea: using the source.db's recID in target.db, getting the rest by relations/references. problem: creating a new record in target.db and putting the recID. and all this from source.db with a button ... oh, and: we'd like to avoid (beeing on a macintosh) using applescript .... any help appreciated. thx, phonoguy.

I have been using a menu file which accesses files on FM Server, and everything has been working OK. Suddenly one of the relationships keeps showing "File Missing," and asks the user to locate the file, but then the relationship is dropped once the file is closed. I have checked obvious problems: corrupt files, etc... but no joy. Other files stored in the same folder, are picked up OK. The system is PC, using windows 2000. I am used to working in a mac enviroment, and can see no reason why one file should not be picked up, any ideas? ( I have checked that there are not 2 files with the same name) Thanks lips

Hi all, Let me try to explain it a bit. Business Tile Wholesaling. Specifics : As for many other Manufactured goods, and specialy when dealing with colors, each production (from 50sqm up to 50,000sqm) will be different from the previous. With the introduction of some ISO standards, each product is stamped with several codes, and wholesalers following ISO should also integrate these codes when re-selling any item. Apart for quality control, it offers a guaranty that we won't be selling items coming from different productions, thus having different caracteristics (size and colors may vary during the maufacturing process). This also gives the custom…

I am newbie to FM5, but have so far figured out how to link two databases using a calculated field (that is the combination of two fields), by creating a calculated text field that is field1: + field2:, in both databases, then creating a relationship in which ID:=ID: . That works well, until I try to add a record. When I add a record, I get the message: The relationship ID is not valid and must be corrected before this field can be modified. I think I understand what is happening, the portal does not know what the values of the 2 fields the calculated field is trying to compute, and therefore, cannot fill in the ID field, to continue adding the data. Can…

Hi, I'm relatively new to filemaker, and any help in this matter would be greatly appreciated. My databases are: Sales (Imported from a text file, basically a glorified invoice) Orders (this is orders to suppliers, the product codes are read from the sales database) Products (There are more than one of these databases, one per supplier) I am trying to work out how to make the Sales database read in descriptions and pricing information from different product databases depending on the supplier. Each product has a 3 letter code identifying the supplier, and all codes are unique, but I can't define a relationship from this field to more than one databa…

I'm trying to create a db for keeping track of callers and their problems/questions/comments. I have a file for the callers, and a file for the P/Q/Cs. I currently have it set up so that when I create a new caller I can select the P/Q/C from a list generated from the records in the P/Q/C file. That works, however I want to be able to count how many callers had one particular P/Q/C and display that information on that particular P/Q/C in the P/Q/C file. When I tried to do this I received an error message saying I had a circular definition or something of that sort. Which is super frustrating, because it took me a while to just get to that point. Second problem, same d…

I have and will continue to have multiple issues with learning how to use filemaker well. I have decided to focus on individual components of my student information tracking system for my small school. I currently have the summaries component working. To be more specific, daily comments must be made on each student. At the end of each treatment week, those comments are presented on a form which displays thus: one page is dedicated to a given student with the five summaries corresponding to the five week days listed in chronological order. We also assign 'behavior points' to the students each day. I have a 'dailypoints.fp5' database that keeps track of their points.…

I was reading a posting that LiveOak replied to and wanted to ask this question. I hope i'm not asking the exact same question with different field/variable names....(we'll see) I have an attendance report that has to be turned in on a weekly and monthly basis. Essentially, Students are listed on the Y axis (column) and days of the week (31 total for one month) are listed on the X axis (rows). Example: (P=Present; A=Absent) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 ... StudentA P P P P P P P P P P P P P P ... StudentB A P A P A P P P P P P P P A ... StudentC P P P P P P P A A A…

I'm working on a db for our little league baseball organization. I've had some good suggestions from the posts I've sent up and through browsing the threads. I'm hoping someone can help with a relation question. Creating databases is not my "day job" and consequently I'm probably asking a silly question. I have a Player ID file, Registration file, Family File, and a Coach File. The fields in the Player ID are specific to each player(ID,dob,calc. age, etc) Since more then one player can come from one family I separated the family file to contain info relating to a family. I use "phone" as a match to fill in the family info(if it already exists) on my main layout when addin…

Hello all I am working on a Database where each Record is a Job with a unique Job No but each Job could belong to a Range i.e. Bakery-Italian. Bakery-French. Bakery-English. etc I am trying to create an Invoice containing up to 12 items in a list, made up of, up to 12 non sequential Records in a Range selected by the user: Job No Range Title Product Title Size & Total Cost, which is calculated on a separate Costing Layout, these totals then need to add to a give Grand Total. I have tried using a portal with different combinations of Relationships but I get either all records or none at all. Help Please! Also is it possi…

Hi all, I have 2 db they both have 1 text field. The first has strings of text for example

I'm sure this is something easy to do, I just cannot wrap my mind around it. I've got two databases, Main and Vendors. In the Main database there is a pop-up field with the vendors listed. The user can view more information about the vendor by pressing a button that goes to the related file in Vendors. My problem is, when a vendor's name changes in the Vendor database the relationship no longer links the Main database fields to the Vendors. I know I should us a serial number to relate the two, but I don't want the user to have to input the number, I want them to simply to pick from a list of vendors. How do I do this?

I currently have one large master file that displays inventory type information. From this file you can access numerous layouts. I want to switch from this to multiple related files. What I can not figure out how to do is to sort just the records I want into different files. Right now I simply sort all of the objects based on an X being in a feild or not being in a feild. So essentialy what I would like to do is if that X is checked it would copy to another file. Can someone please help me figure out how to do this.

HI all FM 5.5 Dev on Win XP I have three files, one a TABLE of linked items, one with a DESCRIPTION about each item and then a MAIN SCREEN for users to make their selections from. Now the DB's are all related, in that in the MAIN SCREEN users select from a drop down list a list of items available from a value list created from the TABLE, once they select that item the next drop down list is provided which is only showing those records that are linked to the first item, also from the TABLE. Underneath each one when they select is a detailed descritpion of teh item provided from the DESCRIPTION file. Now all the aobve works fine. But... After the se…

This is a demo for Mary Silvanos who posted a question on FileMaker Cafe about how to grab a price, defined by a date range and a service code, from a Prices file when entering a date and service code in a Billing file. This demo uses smart date ranges to match the service code/date combination entered into a record in the Billing file with a date range key (all key values prefixed with the service code) in a record in Prices. The relationship also works in reverse, displaying all records in the Billing file whose service code/date key match a given service code/date range key in Prices. Also, when entering service code/price records in Prices, a self relationship o…

How can I return a filepath of an image in a container to a field? Is this possible with relationships? I also need to set another field based on the name of the images - which classifies the type of image, such as "brick_building.bmp" would return "brick" into the category field. --magilla

Hi, This is my first post and I'm a newbie with File Maker Pro. I've been working on a relational database between Teachers, Faculty, Staff and Events that they have attended. So, I want the Events DB to list all of the Teachers, Faculty, etc that have attended each event. Vice versa, I'd like the Teacher, Faculty, etc DBs to list the events that each person attended. What I'm having trouble with is adding and deleting people and events. For example, if I add a teacher to the Teacher DB with a NEW event, I want that event to be added to the Events DB and if I'm in the Events DB, I want to add a teacher to the list and have a new record pop up in the Teach…

hi there, i know this is a simple question. i have 2 db. one is called "work order" and the other is called "materials" materials just has a list of material names and prices. the work order db will create new records and i want to be able to use a pop up list or portal to show the list of materials that are in the "materials" file. i have made a few other relationships to other files and they work great. this one is bugging me cause i know it's an easy answer. thanks peter

I have an invoice file, line items file and credit note file. If I post a credit I want to lookup the details from the Line items and the Sales File file based on the relationships: Credit note: invoice No.>Line items:invoice No Credit Note:Invoice No>Sales File:invoice No. This allows me to bring in from the Invoice all the customer details including VAT exempt status and order No., and from the Line Items file the price at invoice date as well as the product details. When I enter the Invoice number in a new record the client data is brought in successfuly from the Sales File but the product data goes belly up. It brings in two of the same items from the Li…

Does someone have a file that shows a "GoToPageNumber" function? I'm having a lot of problems with this one because I'm such a newbie and the help file does not have instructions at the beginner level. I have a global field called "gPageNumber" (I've had help, obviously! <g>). The whole thing is awkward in terms of for the user and also, despite putting sort commands, the results are getting jumbled up. So, if data is correctly sorted to begin with, it gets scrambled despite a sort that works. It's a db with page #'s and references on a page, i.e., a, b, c, d so end results should have everything sorted by page #, item # on page and then by title, …

The scope of this question may be beyond what anyone wants to tackle

Just discovered the forums. Sorry if this has been covered before... Suppose I'm troubleshooting duplicate records or consistency across similar records, and an internal relation tracks sameness in one field (say, on an id number or phone number); I would like a layout to show me some fields from the other record(s) with this value. (Or imagine text calculation that would stay blank or report "This record seems to share a phone number with " & samephone::name, used in layout as a button to go to that record.) As it is, any portal or relational field shows the "first" related record (by entry order or fixed relational sort order), so that half the time I'm l…

I am trying to come up with a solution that will- 1.add and remove inventory via shipping and recieving 2.list the inventory all together so it can be viewed by sales before making a promise to a customer 3.allow the creation of an item (product catalog ID) without it having ever been entered into inventory before ust by typing it like any other inventory item. I am trying to combine the "Inventory.FP5" template that came with Filemaker Developer to store the information for viewing and the "Sample Inventory Attachment" uploaded to the forum #49882 - 11/08/02 08:34 AM to perform the calculations. I have no doubt this can be done, I just dont know how …

I have a program that tracks customers and their corresponding invoices. I need to write a customer history report that shows all invoices, and the details of any payments on each invoice. My problem is, if i run the report from the invoices file, i cant get multiple payments to show up. If i run the report from the payments database, I can't show invoices that don't have any payments. It's almost like I need the equivalent of a dynamically sized portal which expands and contracts depending on how many payments there are on each invoice. Thanks in advance for any help.

I have a multi-file solution that I have deployed with two clients, and I keep archive copies of these two versions (for troubleshooting purposes), along with my development copy. For some reason that I cannot understand, Filemaker will cross-link the different copies of the solution. For example, if I open client copy "A", FM will open files that belong to client "B"--sometimes simultaneously. This has the potential to really screw up my clients' systems, oir my development platform, as I change settings in what I beleive to be copy "A", only to find that they are copy "B" files. This all is exacerbated by the fact that FM makes NO INDICATION of the actual location …

pardon my frustration... but i can't seem to get a relationship going between these two files of mine. could someone explain, in detail, the steps i need to take and things to look out for? cheers!

Hi all, I'm a noob here and am hoping someone can help me out. I have been searching the forum hoping to find out how to create a history table for an equipment inventory database but have not found what I need. The project consists of 3 tables: EquipmentInventory, EquipmentHistory and Locations (lookup). What I would like to do is insert a record into the history table whenever someone changes the location (via the dropdown). Anyone know how to do this? TIA for any advice you may have.

This is a toughie I have been banging my head on for about two years, I was about to throw in the towel when I discovered this forum. I have have a database of mini courses and a database of participants who wish to sign up for said courses. The "full" point for the courses is 20. Now I can keep a running total of the number of particpants signed up, but I want to put this info into a caculation so when I try to assign someone a course that is full, I will get warning "This course is full, try another." Thing is, I have not been able to automate this, and therefore, I still us the "hand" system to tell when the course is full. Then, I add a validation calculation…

From a main file I'm creating a record (via script) in a related file and writing data on that record. The script in the main file... 1) calls a script in the related one, that creates a new record, assign an unique ID and set the global gID to the value of the ID of the record just created. Then... 2) control goes back to the main script that copies the global in the related file in a global in the local file (trought a dummy relationship) A relationship relates the global (containing the ID of the fresh record) to the IDs in the related file. 3) Trought this relationship the main script writes on the fields of the new record. ------- …

I need two files. I have fileone with ACCT#, AMOUNT, and STATUS fields. Status is A or B. I have filetwo with ACCT#, and DEBIT fields. I want a report that will give me the following totals for each STATUS and for ALL. Total Amount, Total Debit, Balance for all of Status A Same for B and same for Total of all records. I can get close but can't get the Balance for each status separated. What Fields, and relationships do I need. It's probably simple but I can't get the right combo. Larry

We are having a problem where layouts are only displaying 80% of the screen when using the Windows runtime kiosk. Usually when you come back a second time, they redraw properly, but it is not guaranteed. I am using Maximize Window and added a Preview before going into Browse mode and that did not work. Any ideas?

I have a solution which went from a record deletion taking a few seconds to it taking several minutes to delete a single record. The file has 131 relationships and I am wondering if I went over a magic number of 128 relationships? I removed the cascading deletes from those relationships that had them and it made no difference. Any ideas or suggestions?

I am trying to count the number of records in portal, and have it entered into another field? Any help would be great thanks!

Hello. I am working on a filemaker system for people who make clothes. I need to make a report that can lookup values from more than one field, and then return a report that summarizes values from two or three fields in one report, separated by colors, and sizes. For example: I will have a report for the amount of zippers used for producing a total order. In the main database, the user enters the amount of zippers used in two separate fields. This is because sometimes you need to use more than one zipper to make an item of clothes. I however need to do a production report when someone orders multiples, and then my report needs to look up all the instances when Z…

I just found this site and I am hoping that someone will be able to help me. I certainly would appreciate it. I know there is a simple answer but it is eluding me. I have created 3 databases that all have relationships with one another: customers.fp5 invoicing.fp5 and inventory.fp5 invoicing.fp5 is pulling billing and shipping information from customers.fp5 and product information from inventory.fp5 All of that works correctly. I am trying to create a short-cut within customers.fp5. I have 2 layouts - one for billing and one for shipping. I am trying to get it so that when people create a new record and enter the billing information, it automatically…

Hi all, I'm just wondering how you are adressing this need ? Say you have Order, Line Item, a Product, a Parts and PartsInProductsJoin files, and you want these parts to appear in the Order Form for the guys in the warehouse to prepare the goods, starting with the parts for each products. I've somehow solved this for one guy here a while back by introducing the parts needed to the Line Items at the moment of the order. This involved a looping script and a set of different relationships from the Order to the Line Item. How this would be best solved ? - A separate file - The one I'm using ? - Portals, even though limited because of the Print procedur…

Hello all, I have 3 order creation database files that I would like track via a fourth "Shipment Tracker" file. The three files serve as product order creation but differ in their report layouts. Each of the files that I want to track have a unique serial number in three different ranges (i.e. 100000, 200000, and 300000). Is there a way in that I could relate all 3 serial numbers to a corresponding serial number field in my shipment Tracker file?

Here is the layout of my current Solution, I have an order form database and a transaction history database. Currently there is a relationship between the two based off of the invoice id. I created a portal in the order form database so it would display all credit card transactions for that one invoice. That works just fine. The next step I am taking to is so that way the user can create a transaction in order form under the transaction portal and then have it authorize the credit card. Authorization is performed by running a script in the Transaction database. I created a button in the portal in the order form databse to run the external authorization script in the …

I have a 2 file filemaker db one the main app the other the releation ship file. Is it possible to open the file only through the main file?? I do not want that the user can open the releationship file. Thanks TMAS

I use filemaker for an advertising sales database. I have one database of people that I sell to in the education market, another of people that i sell to in Manufacturing another for gardening etc etc All the databases work in the same way and just have different records in for each different subject. My problem is that I have quite a few clients that go into more than one database and buy things from us in more than one subject area. My salesmen cannot tell when selling for instance gardening advertising to them that they have just placed an order in hospitality etc Is it possible that when a saleman flags something in one database that filemaker could h…

I have several related databases that work together to run a biomedical process. One of the databases is a list of individuals. Another db is a list of events. Data elements in events include a date and a category. My client needs to create montly letters, reports and labels for each of the individuals for whom there has been some activity in the past. I need to select a date range and category, and then print the letters, reports and labels for that group of individuals. The problem is that there may be hundreds of entries in the events table for a given individual in a month. I want only one copy of the report, one copy of the letter and one mailing label for eac…

Here is the problem: I have three databases 1. Client Addresses, 2. Client Order and 3. Email Client. When a client place an order it goes into the Client Order (Client ID is the relationship from Client Addresses to Client Order). When the order is completed they are notified by email through the Email Client database (CurrentRecId is the relationship between Client Order and Email Client). The only way I have figured out how to bring the client's email address from Client Order into Email Client is with an email field lookup from Client Addresses to Client Order. When I have tried creating an email relationship between the Client Addresses and the Client Order…