Relationships

I hope someone could help in discussing a good way to solve the following problem. I have a "parent" file A, in which I have a portal displaying records from a "child" file B. So far, so good. For the sake of easy explanation, I have a real-life example: File A contains Customers and that file B contains Events for those customers. This is a basic "1-m" (One-to-many) relationship. Each customer can have one or more events related to it. An event could be one of the following types: Fax, E-mail, Phone Call, Meeting. Each event is marked with the person responsible for that event. So, an event record contains: * The foreign key for the customer * The…

Hello, I have two related databases, [Customers] and [Publications]. To switch between them I'm using the "Go to Related Record" command. This works fine if related records exist. However, when a related record does not exist I want to create a new record. I'm assuming I need a conditional statement to trigger this. Which command should I use and how should it look? Thanks, Kelly

Is it possible to build a relationship to a file on an IBM AS/400? I can import a file with ODBC to a PC running filemaker but not a Mac, but what I really need is an ongoing relationship: When Cust#filemaker matches Cust#400 , copy XXX from AS/400. Ideally I would like this relatuonahip to work both ways so I could update data on the AS/400 from filemaker. Can this be done? Thanks, Steve

Hi How can I link to another database & show the contents of a field as a pop-up list & then select from it?

Hello all, I'm working on a former flat-file database that now includes three related databases. 1. Customers 2. Publications 3. Proposals As I see it here are the relationships: Customers --> Publications (1 to many) Publications --> Proposals (1 to many) Here's where I'm confused. I want to design a nice tabbed interface that will allow the user to switch between each of these three databases and add, delete, and search through the various records. It seems like the easy approach would be to select one database as the master and add several layouts with related fields. My problem is more with adding and deleting records rather than p…

I'm not even sure this can be done. I have a client file with data about each client. I have built a separate 'to do' list where each individual to do is listed for each client. (Any client may have up to a dozen or more to dos. The to do file successfully gives me the details of each client from the master file. Each to do is assigned to one or more staff members. What I now want to do now is have another set of lists generated, dividing the to dos into separate lists for each staff member's responsible. In other words, the one master to do list would generate three separate lists, one for each staff.

Hi all, I'm creating a db to hold articles from various sources on a certain topic. Each day articles are collected and a number of these will be used for a daily briefing. What I am wanting to set up is the ability to link articles together that are of the same or a similar topic - essesntailly threads. My thoughts are to do this with a self join relationship displaying the related records in a portal. So I have a layout to 'create a new article'. My thoughts on creating the thread were to have a link from the 'create a new article' layout that creates a 'new thread article', essentially the same layout except a calculation is used to create a c…

I'm in the steel business. Right now I have a file for customers, a file with inventory, and an order file, I'd love to make an order file that can pull 'found items' from inventory and info from customers to just make one record. I know FM can do it, I just haven't figured out how! Really appreciate some help. [email protected] Thanks Mike

Hi everyone, I have two files, one with a database of models, one that has a calculator to help someone decide what model they want. My goal is for the first file, that helps a customer decide, tells them they need a model in the 9000 range, and then a field in the second file holds that number for all the files. I would want all the models in the 9000 range (or whatever figure they came up with) to be displayed on the first file. The person would then choose one of the models and be taken to its layout in the second file... Does that make sense at all? Hopefully. Basically, how can I search a specific field in another file, display all that meet a …

I have 3 diffrent files. A customer file, A service file and accounting file. Customer file contains the info and custom ID for each person who is going to be in the report. The Service file is for tracking all work done at each customer, and an accounting file for recording payments and tracking how many hours our service plan customers have left. The data entered into both contain the customers uniqueID found in the main customers file. I would like to create a report in the customers file for individuals and perhaps groups of individuals based on there customerID, With sub data from both the service and accounting files. I can get it to show the last record entere…

I would like to know how I can sum up fields in different records (get a number in a separate field) that contain identical information (like ID's). I don't want to have the outcome in a report, but in a unique field on a layout The idea is to create a detailed invoice with a list of different working hours.

When I select the Category from the value list, I want the related items to that record to show up. Currently when I pull down the value list and select the category, the information from the last record is still being displayed or nothing is being displayed other than the Category. Fields: Category(value list) Item Price QOH I am a rookie and I am struggling with lookups and go to related record. If anyone has a sample script or example file they can send me, that would be great. Thanks in advance! Delbert

Can anyone tell me some of the uses of self-relations? (insert use your hand joke here) the whole topic has me a bit misty.

I'm developing a departmental budget. It's going through several iterations, and I need to keep snapshots of each step of its evolution. If I were using a spreadsheet or a flat-file database, I would simply save progressive copies with different filenames. But I'm using a FileMaker solution with 10 related files. Saving multiple copies of the whole cluster with different filenames is not only tedious, it creates problems with script calls and relationships. I tried including an editable value list that will let me distinguish between versions, but that doesn't work either, since the amount of money associated with each record changes from version to version. An anyone sug…

I have a database containing various safety warnings to appear on product packaging. eg do not use near fire, wipe clean only, not suitable for children under 18 months etc. There are 125 different safety warnings in total each appearing in 6 different languages. Each product may require between 3 and 15 safety warnings in each of the 6 different languages. I want to set up a database that collates the various safety warnings for each product and dumps them into 6 seperate fields one for each language which I can then copy and paste onto the packaging artwork. Ideally I thought if I created a file containing a field for the product code and 15 pop-up value lists…

Hi, P.s help! Currently,I have 2 database.In these 2 databases,there are severals fields(repeating filed) in which I need to link together using relationship. The problem now is: Only the first record is working. From record 2 onwards,the fields can't link anymore! P/s let me know if you have any idea,why this is happening. I'm not using portal

Gotta brain freeze tonight... THE QUESTION: If I use globals in a calculation, and the file is a multi-user, will all the users have different calculations based on their global? Why you wonder.... I'm working on a scheduling program and use a global date field as a reference to display particular sets of dates. I want the user to be able to change the global date be able to see various other dates. The schedule file is a list of times with calc fields that display data hoizontally in seven fields (one for each day of the week). The fields are based on calcs that incorporate the global field. Thouroughly confused now?

Dear all, P/s help with this doubt? I've already set up the master file and the related 's relationship but my lookup still cannot work? After I have set certain field to use lookup relationship,do I need to write any script for the lookup to work? Thanks in advance

Relative Path (and that is now the default option in FileMAker Pro 5.5) shows up in a number od places where one file references another. When selected, it causes FileMaker Pro to limit its search for a file to the same relative path within a given folder on a server as was its original creation folder. For example, if in a folder called Company Database, I have two files, one called Companies the other called Contacts, and a relationship is defined from Companies to Contacts wheile the files are being created, when the files are moved to the server, Companies will avoid looking all over the network on on your loal drive for the file Contacts. This is very diff…

Using version 5 I'm trying to access data that is four files deep in a relational database. Both the manual and the online help have a section that says that it is possible to create a calculation field in the master file and use the relationship to refer to the data from the related file. It implies that it is possible to repeat this to further depths, but when I try to create another calculation field and refer this to the previous calculation field there are no error messages, but I just get a blank on the layout. I'm sure this must be an issue that others have met before but as I'm new to filemaker (well after a gap of about 8 years) I just can't see a way round…

Hi, I have some problem about to use FM,I have two question below 1. If I have one field all "A" and the other one call "B" and I nees a condition in "A" to select popup list How can I do if I have 2 values list to select from condition "A" 2.in the caculate box can we use external command? such as function in script? how can I do above? Haruthai

Example: We purchase widgets for resale to our customers. We get these widgets from multiple distributors. Each widget has both a manufacturer's part number and a distributor's part number. Depending on who is cheaper or who has one in stock, we may quote one distributor over another. When I build a quote, I would like to select the model widget (manuf. part number) and then select a distributor from a pull down menu. Once these two items are selected, I need the appropriate cost and distributor part number to come into the quote. Right now, a relationship exists when there is a match between manufacturer's part number in both the Product Listing an…

I have a file that won't remember any relationships except self-joins. I have the "Hide File Extensions" turned off in the folder options. Every time I open the files it asks for the related file. So I tell it where it is and every thing works fine until you close and open it again. THen it forgets again. I even tried recreating the relationships manually. Anyone have any ideas? Thanks, G

posted February 13, 2002 12:06 AM ------------------------------------------------------------------------

Hi all, I have a problem. In my Filemaker document are three fields. Two value lists containing text. One field which shall display the result. e.g.: Value list one has jobs: "Designer, Programmer, Support". Value list two has tasks: "Repairing Computer, Creating HTML page, Helping Customer". Now when I enter my document I choose a job (value list 1) and a task (value list 2). The last field shall now display the time needed. Designer needs for: - HTML PAGE - 1 hour - REPAIRING COMPUTER - 3 hours - HELPING CUSTOMER - 2 hours Programmer needs for: - HTML PAGE - 2 hours - REPAIRING COMPUTER - 3 hours - HELPING CUSTO…

I am trying to create a database with three levels of relationship one Sale has many reciepts which in turn can have many payments. This is for a simple sales system. I am having a problem though. I can not see how to get the numbers of records to appear as I would like. Ideally I would like the sale to have a number Date-number for that day so that each day the sale number would start at e.g.(01/01/02-(sale)1 Literallly 01/01/02-1 and rise by one for each new sale. I would like this format to then follow through for my reciept(most peapole think of this as an invoice) (date)01/01/02-(sale)1-(Reciept)1 Literally 01/01/02-1-1 rising by one for each aditional reciept. F…

After years of doing data base design from FM 2.1 to current 5.5, I thought I was doing pretty well until recently I have hit a brick wall. I called the 900 number for help and found myself only getting deeper in the mud. I have a two part question.... both relationships SITUATION ONE - I have a client who is a LANDLORD and I have created a check book for him. He pays the water bill on several apartments and makes out one check per month. $200.00. However, he needs to know which apartment should be charged with the allocated portion of the bill. Apt. 1 should be charged $55.00, Apt. 2 should be charged $40.00, etc. and all total they should come…

I have 2 data bases. Project.fp5 holds requests for work assignments, and each record contains the field Zip which is a zip code. There is a relationship defined into ZipCodes.fp5, a zip code data file which contains one record for each zip code. Each record includes the field InspCode which represents a person who is given work assignments for that zip code. As I worked in Project.fp5 I needed to change work assignments, so I edited the related field InspCode. I did not realize that this was effectively editing the original InspCode field in ZipCode.fp5. This is NOT what I had in mind. I did NOT want to change the value of InspCode i…

I'm doing a invoice print layout. Where i have a header with the customer info etc. Then th body which is related lineitems for the invoice. Followed by a footer with the totals etc. But it seems that the body shows all the lineitems from all invoices. Is there somthing I can change to make it only show certain ones? Before this way I used a portal but it could go for more then one page so i need they ability to print muiti-page.

Have 2 tables, Main and Component with records related via serial number. I need to find a way to raise a flag in Main when all related records in Component have the same condition met. i.e. - when the "completed" field for all 3 components related to the master say "yes" a field in master automatically says "yes" too. Thanks in advance.

In a file each record is in part a name and an event associated with that name. If a person is in 2 events, then there are two records, one for each event that person is in. Is there a way to automatically display in a different field ("other event"), the other event? A field based on a name matching relationship puts the event from the first occurance of the person in the "other event" field of both records.

Can someone please help me get my head around this relationship and clue me in on how to set it up? I have three databases Jobs.fp5 Laboritems.fp5 (labor line items) fields: task, description, labor rate and time. Materials.fp5 (Material line items) fields: description, quantity, price, extension. The "Jobs" database contains portals of the "Laboritems" and "Materials" databases. What I'm wanting to do is to enter a task in the "Laboritems" portal, then if theres a material, or several material used for that task, enter them in the materials description field in the "Materials" portal and have it automatically be related to the task from the "Labori…

I am not sure if I fully underdtand the query so bare with me it I sound stupid. Do you wish all six fields to have a drop down that will make the other file fields auto enter, I think it would work like this. Create a script and enter the following, it is quite long winded but it works and I am sure that I will think of a better solution with time so please bare with me. If(field 1 = 1) Set Field(Field 2, 2) Set Field(Field 3, 3) Set Field(Field 4, 4) Set Field(Field 5, 5) Set Field(Field 6, 6) else If(field 2 = 1) Set Field(Field 1, 2) Set Field(Field 3, 5) Set Field(Field 4, 6) Set Field(Field 5, 5) Set Field(Field 6, 6) etc....I would create …

Still planning the killer database... I want to have a main database with tons of company info, and have other databases (secondary)that can search (find) records on the main database and allow the secondary databases to make notes that are attached to the main data, but remain on the secondary. Hope that wasn't too confusing. Makes sense to me. I've ordered some books, but can't wait for Amazon to deliver... any advice?

All of these topics about relationships are kinda confusing to me... My Situation: I have 3 databases. - 1 Master (where everything is stored and where all the MAJOR data entry occurs). - 2 Views (where no data is entered but just a place to show the information in the Master). - 3 IT (where data is entered, but only SHOWS certain information in the Master). QUESTION: How do I duplicate a record in databases 2 & 3 as one is created in database #1 without using scripts? Can anyone help!? Thanks! ~Addam~

My head is aching from beating it against the wall; I know this should be easy, but can't find my mistake. I am just now learning relationships and beginning on portals, but obviously I'm missing something. I've got two databases: JobTrack, which houses project info BrandTrack, a new db set up to see very specific info from JobTrack The reason: I've got a small group of sales and marketing people who want to see the status of this particularly large and encompassing project that the creatives are doing for them. 'No problem,' I thought, 'I'll set up a new file and relate it back to JobTrack, so that the sales and marketing people don't actually get into JobTrack, bu…

It used to be simple. Just put a button in the portal row and program it to "Delete Record". Then I upgraded to v5, and it doesn't work. Nor does the "Delete Portal Row", because you have to tell the script which portal row. I just want to be able to click the button in the portal row I want to delete, and delete it. What works?

Hi. I know how to summarize related data (Calc=Sum(Relationship::field)) However, I need a running total in a portal (like a bank book). Can ANYONE help? Thank you in advance.

I am working with FMP 4.1. I am trying to set up a system that allows The Point Of Sale (POS)Invoice to write to Sales History file and reduce inventory in the process. Let's say that I have line item A which is on the invoice, when the invoice is printed the line item(s)is wrote to Sales History (along with all the pertinent information from the invoice), and the line item is reduced in the inventory file. How do I write from one file to the other From POS(invoice) to Sales. Thanks in advance! Brian

I have 3 file setup: Events Lists List Items Relationships are: Lists to List Items by List ID Events to Lists by Event ID The Lists file contains records in a portal from List Items. I need to relate multiple list records to single event. I would like to create a script in the Events file that creates a new list with the current Event ID. This would be assigned to a 'new list' button in the events file. I would like the lists file to use the same Event ID until a new event is created. This is the same type of relationship used between the Lists and Line Items file. Without the a poral(I don't want to use one)I'm lost. I know this is probably a dumb quest…

Hi Folks, I set up a system at school. I have a number of data files sitting on the server for staff to access. For example, PUPIL DATA files consist of: Pupil ID Pupil Name Pupil Surname Year 7 Class Year 7 Set I also have a range of other files such as PUPIL EXAM COURSES which consist of: Pupil ID Exam 1 Exam 2 etc. The same file also pulls in the Pupil class and set from the DATA file (no problem). However, I update the data file every now and then, when a pupil changes the class and set. To do this, I work away from school, amend the DATA file and then drop it on the server again, replacing the out of date DATA file. Unfortunately, when I do t…

I have 5 separate and reasonably identical databases for 5 separate departments. Its easier to give each departmetn only the data they need but occasionaly it would be nice to use one 'super-database' (catalogues, web updates etc.) without having to export from each individual database. Is there anyway to set up a relations ship in which the super-database FIELD1 contains the data from all 5 external FIELD1's? Any other solutions? Thanks, Bruce

I have a series of related databases, for projects(jobs), clients, and timesheets. I would LIKE to click a button in the projects file and lock all timesheet records relating to that project in the timesheet file (so I don't wind up entering more time on a closed job.) I just can't seem to find a way to do this. Maybe Lock isn't the right word; I don't want records of closed jobs to be casually modified, but user-level is too global to screen out by job status. Any ideas, hints, or references? (All files on one machine, with one user, me.)

I have two databases both are related and contain info on one subject but must remain separate. Is there any way that anyone knows to create a new record in both simualtaneously and relate the two? preferably i would like to do this using the create new record option in the menu because this will be a shared database and i do not want to confuse people. if this is not possible is there any way to disallow the use of that command for this database only? any help is appriciated thanks aaron

To describe the problem: In database 1 I have two entries: Newspaper name and circulation of the Newspaper In database 2 I have the field Newspaper, where I have a list field with the relationship to the db1, and a filed circulation. I need the following: when I take the Newspaper XXX from the list field, in the field circulation should be then automaticly the circulation from db1 belonging to newspaper XXX. How can I do this? Thanks for help! P.

hello. pardon me if this sounds foolish, or if i'm in the wrong forum. I have a text filed which the client can enter their comments and such, i also have a file number on the same page. Is it possible to have another page or separate file maker file collect the file number and comment from each page in the database as they enter the information. So i should be able to view all the comments in one nice long organized by file namuber, or any other field choosen. thanks in advance. j

Is there any way to summarize a field from a related record? I have an expense report, all line items are from a related record. Each line item includes several bits of information, including a dollar amount. the expense report needs to have a field where the total is calculated from all of the related dollar amounts. this one is kicking me, I haven't been able to find the solution. Any ideas? If you have any ideas, please let me know! thanks --->PAul

I am converting an dbase system to Filemaker. I've created new .fp5 files from the dbase files by importing records; the resulting file is called "__ converted.fp5". I figured it would take forever to figure out FM but to my surprise (probably not yours) I have already accomplished many interesting reports, layouts, and views that include portals into other "converted.fp5" files. Now I want to get rid of the "converted" tag and create different (permanent) file names for the converted files (yeah I know, I did it bass-ackwards). If I do that, what will happen to portals? I assume that each .fp5 file is an island to itself and is not "aware" of file name changes a…

I have a DB with 5000 records and created a unique ID code based on First Name, Middle Name, Last Name and Date of Birth. When I write a file note, they are stored in a second DB, utilising a button with a script that says, copy the current ID code and paste it into a new record in the file note DB. A portal from the first DB allows me to view all file notes for one person (because of the ID code match). The data in the main base is refreshed from an external source weekly, but generally changes are not made to the data used for the unique ID code. When I was away some space cadet allowed the refresh of data to change names (and therefore the ID code in base one) w…

I have two files, OrderEntry and Receiving. Each record in OrderEntry corresponds to one PO number. OrderEntry also has a portal linked to a file called OrderPartJoin that lets me input multiple discrete parts per order, along with the corresponding information for each part. Problem: I want to be able to duplicate each record (along with all of the parts in the portal) from OrderEntry in Receiving, so that I have one order per record. The trick is that we often receive parts from an order in multiple shipments (if we ordered 1000, we might receive 200 in a shipment, then 400, then 300, then 100 to finish the order). I need to be able to track the number received for e…

Several things aren't clear. For instance, what exactly are you trying to do? I think that once you can clearly express what you want, the answer may be fairly simple. Looks like you want to be able to subtract, automatically, from QOH in the inventory file, anything ordered in an invoice. But I'm not sure. (By the way, how does "Stcklvl" differ from "QOH"?) If so, this can be done thru multiple relationships, but you need to know, exactly, the mechanics of what you want to accomplish.

We have a main Databese with several import routines and relationships. What are the main dangers of doing this. The import routine is ran maybe 4 or 5 times per day and the relationships are a mixture or one to one and one to many. Obviously if a filename etc changes it would cause problems, but are there any problems if the Databse is used intensivley.

I'm a new user of Filemaker. I met a problem by using it for some data in my lab. We have several diffenrt fiels now, and one of them is a master file. I want to build a realtionship between this master file and another file, which is to relate one field(A) of the master file to two fields(B & C) in that file. And we need only one match, (A match : or (A match C). How can I do this? Thanks a lot.

A Many-To-One relationship is the just opposite of the One-To-Many relationship. It is not any different programatically just different to think about. It is like a Child-To-Parent relationship. Set it up exactly as you would any One-To-Many relationship.

hi...i'm new to FM...i'm running 5.5 at work if that helps. i've got a master DB consisting of a sequence number (arbitrary number as primary key) along with a 'CourseID' field (foreign key) and an (EmployeeID) (foreign key)...each has their respective associated fields from displayed as well. i'd like to know if i can somehow cut down on data entry by having the DB automatically create each combination of courseID & EmplID for me rather than entering each individually. from here, the sequence number increments for each new record. for instance, courseID 1-EmplID 1, CourseID 1-EmplID2, CourseID 1, EmplID 3...etc. i have about 100 employees and 50+ classes to cons…

What am I missing? I am running three related DBs on Win NT/FMP Server. The parent DB Invoice Master diplays customer info and the items,cost codes and costs are displayed with a portal from DB Invoice Cost Records (ICR). ICR is related to DB Cost Codes, where the short codes i.e. P-S, P-AS.... are associated to specific dollar amounts. Problem: When a user selects Invoice Master it opens the other two DBs which are viewable to the user (yes, they are initially hidden from the Host list using "multiuser-hidden"). I do not want the user to dink with these two DB's. Is there a way to keep them hidden? When I tried putting a few user restrictions on certain child DB f…

I have a 5,000 record file with 200 users based in eight locations accessing via browser. About 175 regular users update many fields of each of their 25-30 records one a record at a time, while the other 25 "specialusers" loop through and update a few fields of 25-30 records at a time. There are about 20 regular users and 3 "specialusers" at each "location". The fields accessed by the regular users and the "specialusers" are mutually exclusive. At a given point in time "A", I have to print all the records and distribute them to each user. The regular users get a copy of each of their 25-30 records, while the "specialusers" get a list of only their fields for all the r…

I'm trying to make a pair of simple related databases, one with employee information (name, department, social security number, usual shift, pay rate) and a second one to track work (employee name, department, date worked, start time, end time). The relationship seems obvious enough to me (if last name = last name), but I can't get that to work. Here's my problem: Let's say I have two employees in the employee file, Mike Johnson and Sandy Johnson, when I go to the Track Work database, it always shows the first one alphabetically. Is there a way to see all the employee names in the Track Work database so I can select the right record/employee? I've tried a portal with a …

Hi all, My first post. Have already gleened much from the forums. Many thanks to all the masters. Here's my One to Many "dilema"... I have 2 dbs - "Master Item" (One) and "Component" (Many). "MI" has a unique serial number assigned to each new record. Through a script between "MI" & "C", a user increments a "component number" field by one for each new component created (this number is held in the Master Item record), creates a new record in "C" that sets the serial number from one global, and sets the new component number from another global. The two are read into "C" and the relationship is made (i.e. - P4100-1) Here's the fun... From "MI", I need to be able …

I have created a drop down list in one database from a field in a related database that is just now giving me strage issues. (I created the relationship about a year and a half ago) When a user clicks on the field that is the drop down list it shows all the data I have in that field in the related database but adds info like names of cities and internet news servers and remote server names. This additional data just showed up a couple days ago and I can not track were it is comming from. I have tried rebuilding the relationship and I still get the garbage data included w/ the valid. Any ideas? I have run out.

Sorry for a newbie question, but here goes: Let's say I have a simple FM database and one record currently showing. Is there a way to set up a relationship so that if I create a new record in a second database, all of the relevant info from database #1 is inserted automatically without me having to type the related field info? Thanks! Russ Conte

I've been looking for the answer to this question here, but I haven't seen it phrased exactly like my situation. I have 3 files: Customer Master Sales Contact History Sales and Contact History are displayed in Portals in the Customer Master. The match field is the email address (I run a web-based business, so that's the only info I'm guaranteed to get from customers). When a new sale is created the email address is entered, and the rest of the customer info (name, address, etc.) is Looked Up from the Customer Master. So far so good. It all works seamlessly, with lots of records displaying quite happily in their portals in Customer Master. But when it comes time t…

I tried filemaker 5 and its relational database capabilities: Assume you have clients with a unique login id in database a, you store their login session times in database b: create database CustomerData, fields: login (type text), data (numeric) create database Customer, field: login (type text) Now, make a relation from customer to CustomerData with the login name as relation. Created a layout in database Customer, add the field "data" from related database "CustomerData" then type in some data in CustomerData: user1, 12345 user2, 23456 and add user1 user2 to database Customer. Result: the "data" field of database "CustomerData" will be seen …

I am frustrated and on a deadline to finish some work. I hope someone will be able to help me urgently. I have a seriously complex solution in v4.1. When I convert to either 5.0 or 5.5 (same problem occurs on both Mac OS 9.2.1 and Windows ME) one of my scripts that takes me to a related record from a portal to and displayed that record in another file stops working. The record displayed at the end of the script is always the first record in the portal. Has anyone else experienced this apparent anomaly? Does anyone have a fix? Thank you in advance for your answers.

I have a Reservation.FP5 file with a self-relationship portal. I'm using a calc field "Row" Status(CurrentRecordNumber) to show the portal row number. Sample portal: Row RecordID 1 1047 2 1051 How can I pull the row number data into another file that has a many-to-one relationship to the file above? [ December 17, 2001: Message edited by: jfrick ] [ December 17, 2001: Message edited by: jfrick ]

Let me just clarify your question... You have a patients file and a letters file and you want to connect the letters file to the patients so that you can send certain letters within the letters file to a patient. yes? You may want to create a reltionship between the two files using the Letter_name as the link. Create a field within the patients file for Letter_name and format the field using values(Letter_name) from the Letters file. Otherwise, you may want to add more fields within the letters file to link a specific letter to the patient by patientID#. Then the Patient ID# will be the link between the two files and you can also set up a Letters portal in the patients …

Hey all, I think that the inherent problem here lies with One-to-Many relationship. Let me explain. I have two files: 1. Company => one record per each company 2. Employees => several records per each company These two are connected on CompanyNumber, a classis One-to-Many. I want to be able to view how many employees there are in each company (just a number) from Company file. Fairly simple, I use Summary fields and then break the Total field in FamilyNumber in Employees file, and then I can drag it on the layout in Company file. But for this GetSummary field to work, the user must first sort the Employees file on FamilyNumber. This wouldn't be a prob…

I think the answer is "no", but is it possible to select multiple related fields on a layout (all the same relationship), change the relationship, but keep the fields? I have several related files, each having the same fields (Baseball::Notes 1 through Baseball::Notes 37; Basketball::Notes 1 through Basketball::Notes 37). I would like to go to the Baseball layout, copy the 37 Notes, paste them onto the Basketball layout, and change in one fell swoop the relationship for all of the pasted fields from Baseball to Basketball. Not possible, is it? I have 37 Notes for each of 18 sports. I would like not to have to change the relationship and specify the field 666 times.

What I have is a standard set of databases...a many-to-one relationship between product.fm5 and plantdesc.fm5. People can open up the rose database and see how many different pot sizes and plants we have for each variety. This works great for the various departments (perennials, roses, bedding plants etc.) as they each have their own database with custom value lists etc. Last year I only uses one non-related database and was able to do administrative functions (clean-up, global changes etc.) and post it on our web site as a price list via cdml. This year I have 7 different databases and am at a loss to figure out a structure which will allow me to access all the recor…

For a solution I'm using a many to many relationship by using a 1 global (text) field with several keyID's on 1 side and a file with many related records on the other side. I'm actually using FM's nice feature of indexing every 'word' to create a multiple key with just 1 field. The gKey on the master side has multiple entries separated by the paragraph symbol. On the child side of the relationship is a normal number key field. Each user can collect his/her own set of ID's in the gKey field after which a script can be run to update all child records in one go. The question: - In FM4.1 this relationship works fine but would be have a potential problem when upgrading to …

This should be an easy one for the Gurus: I have two simple databases: DB1 is a simple call log for a tech support team. DB2 is a simple knowledge base. I need to have the option to create a new record in DB2 from some of the fields in DB1 by using a simple switch in DB1 such as "Add record to DB2: Yes/No" I'm a graphics/CAD guy but I get very turned around with databases. Any help would be greatly appreciated. Thanks, Dave www.daviator.com

Hi, I use many years Access form microsoft, but discovery Filemaker by casual and I think that much better than Access, anyway I still dont know something in Filemaker, I have all ready make a aplication in FM but I would like to access some exterior database with VBscrits that I have already done, so...is there any item or event in Filemaker that start the execution of that

Not sure this is the correct area for this question, anyway here it is, please HELP!!! I have records in one database (rosters) that is sorted by a field called "sport." Every record has a name(athlete) and their sport. Each athlete is given a rank from 1-20 (20 being the maximum for this particular report). So what I want to do is a print a report that does a find/sort based on sport(got that part), then sort based on the rank given to them. Note: not all sports will have 20 athletes at the time of reporting, but needs to show all 20 variable in order 1,2,3...., even if rank #4 is blank. This is either very complicated or so simple I can see it. Thanks for the help…

Hi all: I'm sure this is a common scenario, and I'm sure it's right under my nose, but at this point i have to admit that I'm completely stumped... I have a multi-user database of 'Contacts': the standard names and addresses. This DB has to remain multi-user, as it works with other databases in the same solution. However, I want to be able to synchronize this DB with my Palm via Filemaker Mobile. FM Mobile doesn't work with multi-user databases. Which means that I have to have another single-user database which contains all the "Contacts" db records; let's call it "PalmContacts." I want to set it up so that every time i create a record in Contacts, the same record…

I have been working on revising our department H+S database. I am working on setting up a master "workstation" database which would have relationships with others like "CPU", "employee", "monitor", "software", etc. It's a pretty big undertaking for me considering the most I've ever done with Filemaker is update the old one, never having to build one from scratch using relationships, portals, elaborate scripts. On to the first of my questions. I've somewhat completed a "CPU" database listing the base configurations of all the CPUs we have on the floor. i.e. a G4 QuickSilver representing one record would list all possible options within each of its text fields (Hard Drive …

I have been racking my head to make the follow work: I have a "clients", "contacts" & "quote" database file. In my "clients" data base I have fields for company name, address, city, etc.. In this database I have a portal to my "contacts" database which has fields for contact name, email address etc.. I have set things up this way because I have multiple contacts for each client. Where I'm having a problem is in my "quote" database file. I want to be able to have a pop-up menu where all contact names show up. When I choose a contact in the pop-up menu I want the related company name and address to pop-up in a company name & address field. I…

Here an attempt to rephrase my earlier post about 'using related fields or copied fields with synchronization issues?' into a more general question. ( I hope that the reason for no further replies isn't the fact that I may have offended 'Old Advance Man' by calling him 'Steven', if so I hope he accepts my apology) My question: If a database-file has a field that is auto-entered with a looked-up value (done specifically so that the field-values can be stored and indexed for usage by other relationships to this database-file.) How do I approach the issue of synchronizing changes that are made to the original field that was looked-up for the auto-enter. At the moment I s…

FMP doesn't complain about my relationships but results are flakey. I have 3 files (Positions, Employees, and Personnel) with Personnel being in effect the intersection of Positions and Employees, i.e., it contains both the Position and Empl IDs. Relationships between Personnel and the other two files work fine in both directions. To set up a relationship from Position to Employees, I use the Empl ID that comes from the relationship of Position to Personnel(bases on Position ID). FMP says OK, proceed. But when I display fields from Employees in a Position layout, based on the afore-mentioned relationship, life is strange - when I open the layout and browse thru it the fir…

I have created an order form we fill in while our customer is on the phone with us. We enter the Product ID and auto enter the description. We offer quantity discounts, for example; 1- 12, 13 - 24, 25 - 50, 51 - 100. How can I get the quantity discount price to be automatically entered based on the quantity we enter in the quantity field? Thank you in advance for your help. Gary

I'm sure questions like this have been discussed/answered before. If there are some previous posts I should check out please point me to those links instead. I was in doubt putting this question here or in the 'Define Fields' Forum; if I entered it wrong please move it for me. I'll describe the issue with 2 of the files/tables I'm using, there are actually more files in use for this database system but the same principle would apply. The 2 files are COMPANIES and CONTACTS, COMPANIES has a one-to-many relationship to CONTACTS I started, as I think it should be done, by storing all unique information in one place only so e.g. the 'Company_name' field exists only in the CO…

I have 3 files: Products, Transactions (includes all sale and non-sale customer contacts), and Summary. The summary file (at least at this stage of building) contains Name, Address, etc, as well as portals for Contact History and Order History (from relationship w/Transactions). Match field in the Summary file is Email---since my business is web-based, all my contacts have email addresses. As with many posters here, I'd like the Summary file to automatically show records of customers who are created in the Transactions file. The last thing I want to do is manually type data into their match fields just to Lookup all their addresses, phone numbers, etc. But here's the cat…

Hello all, I have a database requirement that I can't seem to figure out. Here goes... After entering an order for a system, I need the database to create multiple purchase orders that will go to each vendor of the parts necessary to build the system. The vendor and customer information and parts list lookup seem easy enough. But it's the multiple purchase orders from one order entry that has me stumped. Any ideas would be greatly appreciated. Thank you in advance, -Rob

I have two files that need help on relationships. I have one file with things like member name, member number, etc. The second file has today's information. I need to look up the data from the first file by either member name or member number. I have successfully created relationships by using either the member name with a lookup (pull down) or a member number with a lookup. If I base the relationship on the number then I can't lookup by name. When I try to put a name in the field, Filemaker comes back and asks for the name first. I would like to have a pull down lookup by either name or number. I have tried to find a book on multi relationships in Filemaker, bu…

I have created a "Prospect File" listing fields for name, address, telephone numbers of high schools I will import from comma delimited file. Also created a "Contact" file for contacts, with fields which will be used to fill in personnel contact information about each school. I have created relationship both ways using "High School Name" as matched fields. My tests show relationships work across both files with auto fill of needed data from one file to other. When I import data into "prospect file", the I want to auto create a "Contact" record for each school in the "Contact File using the "High School Name" field. Is there a way to have Filemaker do this, or do …

I'm working with 2 files, which I'll call A & B. A will be the master file. In A I have the "track#", "dept", "act_loss" fields. In B I have the "track#", "amt_rec" fields. I'm trying to establish a lookup field in file A (master) that would correspond to the "amt_rec" field in B. In file A I've defined a relationship b/w A&B based on the "track#" found in both files. When I create a lookup field in file A called "amt_rec" and specify the field in file B the field is blank. I thought I had everything set up correctly but it's obvious I don't. What am I overlooking? Any help would be much appreciated. Alain

Right on in... Company.fp5 and Pubication.fp5 One company has more than one publication and related through company name. I want to have a layout in Company.fp5 that allows a user to choose which publication they want to edit from a list of all publications. (So far this I can do Value list of publication_names is created from all publication records through related field.) What I needs is a way of scripting a button to send the user to the appropriare record within company.fp5. ie. The user may only know the publication name and not the name of the company it is associated with. So I want to give them a way to choose the publication they are wanting to look at a…

I have two files. clients.fp5 and events.fp5 and I want that some clients participate in some events but other no. Every event has a ID field that do it unique. In events layout I have a portal with all clients and I want to select some one. How can I do it?? Thank you very much and excuse my English. -)

can anyone help??? I'm trying to get my Master DB to create related records every time a new record is created in the Master. I've followed the help procedure, the user's guide and experimented every way i can, but it ain't working. Student DB (many fields) ID (number, auto enter serial, indexed) Surname Photo DB ID Surname Relationships Student DB related to Photo DB ID::ID Any ideas?

Newbie needs help… with this time-card design. I think I need 3 tables DailySetup(repeated on all time cards) dayID, DateWorked, Crewcall, GeneralWrapTime Employees: empID, Name, ContractNumber, JobTitle etc. DaysWorked: dayID, empID, IndividualStartTime, MealBreak, EndTime. Rather than fill (on a daily basis) each time-card for each employee, I want to enter times for ALL employees on a grid/template/portal for each day and then at the end of a work week print each employees individual time card. Entering all employees on one grid or in one portal window should (i hope) make it easy to look at the average hours worked for a given day and calculate the approximat…

We have a central client database (client.db), and want to create another db for invoices (invoices.db). The problem I have is that I want to run a script in client.db (initiated by clicking a button) that will open the invoice database and create a new invoice for the current client (in client.db) Therefore there will be many records (invoices) in the invoice.db against each client. Can anyone help?:?:?? Thanks

Hiho, I've been getting lots of help from the very knowledgeable people on this discussion board, and a big thank you to all. I thought I could figure this one little probelm out on my own, but it seems I've stumped myself again. This is kind of a 'basic' expansion on the FMPro example of companies and members related records. I have one file contact.fp5 that is related to a company stats file 'company_stats.fp5' through the 'compnay name' . What I want to have done is have a company record created every time a new company name is written in the company field in a contact record. I can get this to work only if I inlcude at least one other field from the company_stats…

I'm performing a FileMaker implementation. The old DB was an Act! db which they had set up using 'groups.' The groups allowed them to fax all clients located in, say, Kentucky or whatever. The way this was done was by going into Groups, Inserting a new group, then importing all entries that matched a specific criterion. Is there a way to set up groups along these lines in FM? The 'groups' in FM are quite different... Jesse

Perusing over the FM Pro example of a Company with Members to create a relationship where multiple members can belong to each company, I thought my design would be similar. I have one file which holds records for schools - school.fm5 (Name,Location,Type,Address,Phone,Fax) I also need to keep track of which grades a school has and how many students in each grade. I have a second file grade.fm5 which has (school-name,grade,count). I related school.fm5 with grade.fm5 through school-name, I have a working portal in the school.fm5 that correctly allowed creation of multiple grades and corresponding student counts. Great. My little quandry is how to add a year field…

Since upgrading our pc's OS from Win95 to Win2K related files take forever to open. This database has been around as long as I have - well almost. It's hosted on WinNT 4.0 We have several other hosted newer databases that work great. I think its the relationship and the "Filespec" if your familiar with that term. I've tried re-establishing the relationships but it doesn't seem to help. Any ideas?

I'd love to hear if anyone has experience of designing and setting up a user dictionary. As a translator and an FM user, it didn't strike me as a particularly challenging project (a language1 file, a language2 file and a link file for Spanish-English, English-Spanish), but it's not quite working. Each language file has a relationship to the link file (e.g. Sp_term_ID::Sp_term_ID) and a portal through which the user types in however many translations... and the Allow creation of records box is checked. Any ideas? Thanks WillJD

I need some advice from those of you who use relational databases. I'm very familiar with FileMaker 5, but have limited experience with relational databases. I want to create a solution for our newspaper that will allow our sports clerks to type in statistics from sporting events that I can then export to our Quark Publishing System. I have created a database with team name, player first and last names and position. In another database, I have 2 conditional value lists that let me select the opposing teams from that first database and display the rosters in portals. That works fine. But how do I handle the stat information from each game? Would that be in a third datab…

We need to export records in order of State, City and then Name, each are separate fields. The State and City fields may be alike in numerous records. The Name will be unique. We need a heading of State and a City heading not to be repeated on every record, followed by the names. HELP!

I have been working with FM for some time now but I still feel like a beginer. I would like to know how to create a Line Item File. I live in Perth Western Australia and as much as I love it here, when it comes to FM there is nothing and nowhere to go for help. I have a Client File for personal information, and Policy File with all the policy information. The information from the two Files go to the Letters File, there I generate a report for the client with updates every 10 days untill the policy is accepted. All this works well. But now I need to create a Line Item File, so that I can keep trak of all the letters sent,but Im not sure how to do this. Can someone h…

Could someone help me out with the following problem: one of my databases is updated from the web. Depending on the "status" filed, I need FM to automatically create NEW records in another relational database. For example, if someone updates the field "status" with the word "customer" in the "MAIN" database, I would like to have a new related record created in the "CUSTOMERS" db automatically. Is it possible? Since the entry into the "MAIN" db is made from the web, portal seems to be of no use (I understand that portals can not be updated from the web using CDML and custom web publishing). I am new to FM, so any help will be appreciated.

One thing missing from FM Pro is an entity relationship diagram. Is it available in the Developer version? If yes but I can't afford the developer version, is there a cheaper alternative software existing on the Mac platform? Thank you, Luc