Relationships

This is similar to a previous post only different. I have database of contacts and a seperate DB of fax cover sheets/memos. I have a relationship using last names in the fax cover DB that automatically fills in the first name, company, and fax number for reference and printing. My problem is that I have several customers with the same last name (and not Smith either). As I've read and as happens, the Fax Cover DB only returns one "Smith" even though there are different records with different first names/companies. Any real simple ideas that a non-database person can grasp? Thanks!

Newbie here... I have a main database with a list of products for advertising. There can be more than one of a product because there may be different versions of the way the product copy was advertised. I have an advertising event database that is a replica of the main and has a relationship with the main based on the sku field. When you enter a product sku into the sku field, all relevant advertising data is pulled into the other fields in the event db. Since I am allowing for duplicate skus as mentioned above, how can I prompt the user that duplicate skus exist and they need to choose one? The relationship/lookup I am using obviously will pull in the data…

Everyone, I must admit, I'm new to Filemaker... I've played with some databases in the past, but, I'm starting to get a real appreciation for them and what they can do. I need some help, and I'd appreicate if people could post some ideas on how to achieve what I want to do I'm building a point of sale system. I'm not building it for any reason other than I want to see if I can do it, and I've reached my first hurdle Here is what I want to do: I have a field called sku1 (part number) and a field named inventoryname1. I want to enter a part number (either typed in, bar coded in, etc) and have the inventoryname1 appear: SK1981 Golf Balls 10 …

I am working on a project for scoring and reporting student tests. The data will be imported from a text file (generated from a scantron form). Once imported, it will be scored (checked against a key). Each test question must be identified to address a particular state mandated skill (objective). I need to be able to report the data in format like (+ is a correct response): Question #____1___2___3___4___5___6___7___8___9 John Doe_____+___A___B___+___+___+___A___B___+ Jane Doe_____C___+___+___+___+___A___+___B___+ I have looked at other ("professional") solutions that use a flat file. For each question there is a correct response, student response, state obj…

Hi, I've got a couple of issues I'd like to discuss. First some background on our system. We have 3 computers running Win2000 and Filemaker Pro 5.5. There are about 5 regularly used databases sitting on one of the computers and the other 2 machines share them. The admin chick's computer is the one that they are stored on as she uses them most often (every day). Sometimes one of the other users will open them first and "host" the databases for the other users - I reckon this is a bit of a problem, can someone confirm this for me? The other big problem is that occasionally (used to be about once per week, now it's not so regular) the admin chick would be in …

I have a database with toner cartridge information "Copier" It contains fields with Printer Makes, Stock Codes, OEM Numbers etc....All I want to do is take the data from the "Copiers" database and display them in the "Main Menu" database.. I have a "Primary Key" in each database "Primary_ID", I created the realtionship with the "Main Menu" database and matched the "Primary_ID" from "Main Menu" to the "Copiers" database. But for the life of me I can't seem to display the information from "Copiers" to "Main Menu". Any help would be much appreciated, I know this has probably been covered. Any point to a thread or basic explanation to revise my sheer faulknerian id…

This must be a common problem, but I don't quite know where to look. I create lists of our members whose memberships have expired. I do this on an irregular schedule. I want to log this date (manually is fine, since it may actually take several days). I would like to keep a record of all these dates. I also want to do calculations based on the latest (or next to latest) date. For example, all members who have gone deliquent since last updating. (But to be safe I'd probably want to enter the current date in before I create the list to make sure I don't forget). I tried creating a global variable in the main database. I then created a related database with two …

I run a multi-user system using FMServer 5.5 on Windows NT 4.0 and all of a suddenly the relationships disappear from a file at the core of my system. The file is otherwise unharmed and the service does not go down and there is nothing bad showing in the Application (or system logs). Has anyone come across this problem? Do you have a solution. Could it be: outside influences on the HD corrupt data corruption on a layout? Help?

I'm currently designing a rather complex FileMaker solution and would like to get some opinions/advice regarding how to best handle the creation of related records. Here are some of my thoughts: I do not want users to enter data directly into portals. I find this very hard for most users to understand. I also don't want them to ever have to directly manipulate the match field contents. One aspect of the solution is a contact management system. One database contains the company/organization information. Another contains the contact information. Contacts can be children of companies, but do not have to be. I'd like for the user to enter contact info, then l…

Hi there, Ive inherited a nightmarish solution, seems like a classic One-to-Many, but the IDs are problematic: File1 is named *Work*, File2 is *Salary*. File1 has fields: Employee ID (4 digit number) Machine ID (1 digit number) Jobs (numerical code) Hours (number) PK_ID (combination of Employee ID- Machine ID), not necessarily unique. This is the Many side of relationship. File2 has fields: Employee ID (4 digit number) Machine ID (1 digit number) Salary per hour (number) PK_ID (combination of Employee ID- Machine ID), here it’s unique. This is the One side of relationship. These two files are used to calculate the earnings…

I have a database that identifices species. The idea is that if we know for sure what the Genus is (a Y/N field denotes this), we can pull the Family and Class out of another database. However, it's not always the case that we're sure the Genus is correct, and in that case we need to be able to manually enter the Family and Class What's the best way to do this? My first thought was a calculation (case KnownGenus=Y, Rel::Family,"") , but of course you can't modify calcuation fields. the other idea I had was to put the above calcuation field *behind* a user editable field, but that might look ugly if the user doesn't change the data after KnownGenus is se…

I have 2 files: a Member file and a Course file. I also have a third file: Member_course, to match MemberID and CourseID in the two files. I've made a layout for my course file where I register a new course, and there is also a portal showing all the members that have joined the course. I have also added a field (popUp-list) connected to a ValueList. This valuelist is SUPPOSED TO only contain members who HAVE NOT joined the course yet (I have only managed to make it contain ALL members, but that is not very user friendly). By selecting a member from the list, and then clicking my "Add member to course"-button, I add a new record in the Member_course…

Newbie question. Ok, I got 2 relational db's. "Horse" & "Horse Tasks". Now, on one layout of "Horse" I want to type information into about 4 fields, and then when I click a button (more than likely to run a script) it will create a new record in the second db (Horse Tasks) and place that info into the appropriate fields. Ive tried everything that I can think of, which isnt much <lol>. Best I can do is make it produce the new record, but it stays blank and overwrites another record. Any help would be greatly appreciated.

hey all i seem to be having this mental block how can i have one db C which is a listing of all records in db A and db B sorted by date and time (which are the common fields to both A and : pls help this should be easy, no?? my brain just isnt happening on this

hi all. i'm running fm pro6 on a pc with windows me. i'm also new to filmaker, so bear with me. and i'm using it to work with the data i've collected for my phd thesis, so please bear with the odd db and field names. ok, right now i have 4 dbs: titles, monuments, family and officials. their fields are as follows: titles - name, date, complete list, eps, hons, admin, mil, pr monuments - name(ego), date, type, loc, desc, scenes, ind/scene, titles(of ego)/scene family - name(ego), date, members officials - name, date i've entered all the data in all the fields for the titles and monuments dbs. i should also mention that a number of these officials shar…

Database "voters" is related to "voterhistory" by the field voter_id. In voterhistory there's one record for each year a voter participated in an election. Each record consists off voter_id and year, both text fields. For printing purposes, I want to summarize all the related records for a particular voter on one line, instead of in a portal. The output would look like "2002 Primary, 2001 General, 1997" for example, where there are 3 related records for the voter in this example: record 1 -- year="2002 Primary" record 2 -- year="2001 General" record 3 -- year="1997" I'm at a loss as to how to accomplish this -- all help much appreciated.

Hello all, I am currently working on a database for my company that connects Employees to -> Hardware -> to Software. I have an existing database of all the information I need (Names, Serial Numbers, Versions, etc.) I have created an Employee database, that based on a match field of the computers name, fills in specs about the computer / hardware they are using from another file. In this same employee database file I want to link in software info based on a match field of the registered users name. My question is how can i get FM Pro 5.5 on Mac OSX, to display multiple related fields based on a match field that has multiple matches? Example…

Hi, I want to attribute a Price Group to each of my Products in a 50,000 Product.fp5 records list. The Range of each Group is already established in a PriceGroup.fp5 file. Each products price is already rounded at the nearest quarter, but the PriceGroup isn't. I want 12,50$ to match Group 5 with Multikey values of 10,11,12,13,14,15. OK....I keep the post here... I can't believe it happened again, as was noticed by another fellow here. Found the answer while posting it, after a 2 hours struggle. Round the calc with Round(Price,0) and makes it relate to the Multikey in the PriceGroup. Now, I'm still open for better solutions...except…

help is appreciated. thanks in advance I am trying to create what a think should be value lists with relationships what i am trying to achieve is having a drop down list and then a corresponding drop down list for each topic. for instance if someone selects the body part "chest" from the first value list then a list of exercises would be displayed relating to chest in the second value list. the first list would have a drop down of say each major body part chest, back, arm, leg and the second exercise type would list those related exercises. thanks

Hi, With FileMaker Pro 6, is it possible to define more than one match field for a given relationship? If it is not possible is there any workaround? Does FileMakerPro 6 allow to link files by more than one field? For example I want to create a relationship between 2 files. The master file has 2 key fields (CountryID, RegionID). The related file has the same 2 key fields (CountryID, RegionID) plus one more field called City. I want to display in a portal all records from the related file that match to a given set of key fields values from the master file, i.e, I want to display all Cities in the specified CountryID and RegionID. Thank you for the he…

Hi all, I am working on a database that is designed to streamline the programming process for teachers. My question is - is it possible to allow more than one choice on a page A little more detail ~ Teachers are presented with a page where they have to choose an outcome according to a code. Once their choice is made the outcome for that code is presented for them in text box. What I want to be able to do is also display the indicators for that outcome (there may be 10 or 15 for each different outcome) as a check box so teachers can also choose what indicators they will work with as well as the outcome. The indicators will be different for each o…

Is there any round about way to run a script in another related database in order to bring up a related database report? I am using Portals in my main database (main db - Parents Name, related database - there kids and grade info). I cannot create a report in the main database sorting on the portal information (i.e. Childrens first names within a parents last name). When I attempt to create the report, it only sorts by the first child in the portal. If each child is in a different grade, it wont split it up. therefor I have to create the report from the children.fp5 database which is a related db and call it from the main DB. WOW! sorry to be wordy.

I've read many threads on related topics, but none seem to quite match what I'm struggling to do: I have two tables, person and account, joined by a relationship of person:account_id to account:id. The account table also has a name field, and I've defined a value list 'All Accounts' that looks up all account:name values. Users need to be able to select from the entire list of accounts when entering a new person record, and be able to enter a new account in that field if necessary. The system should enter the account:id value (auto-created for new account records) into the person:account_id field when an account:name value is selected from the accounts value list…

I'm trying to read all relevant posts about relationships and doing finds between related databases, but I am somewhat confused by the language. I think it's because my related files don't follow the traditional definitions. I have a database in which people can enter information on donations - date, type, amount, and whether or not a thank you letter was created. Whenever this information is entered, a new record is created in a related database. The reason for that database is to make finds/reports/etc. easier. So, which is my "parent" file and which is the "child" file? I would think the one where you enter the information would be the parent file, but because yo…

From a complete fm newbie (for like 2 hours) with a problem. I have 3 fm-files with data (reference, publication, author) (I have more but solving this would solve the rest) structure reference: publication_id (number) author_id (number) structure publication: id (number) name (text) structure author: id (number) name (text) In reference I want a pop-up list of the authors name. When i pick a value from that list I want author_id (in reference) to change to the corresponding value defined in author. I also want it to work the other way around. If I change the value of author_id I want the selected value in the pop-up list to change…

Hi All, I have 3 fields ...name, department, score Name A, Computer, 100 Name B , Science, 90 Name C , Computer, 20 Department is an unstored calculation, how many department in the file, I could get the average of score of that department. In this example, it produces 2 department with Computer and Science. But the problem is deartment is an unstored calculation, is there a way to achieve this??? Thanks Anh Tran

Hi, I have developed a job bag system with which I am experiencing some performance problems with loops. The system is served by a Mac G4 to around 10 cross platform hosts. This is my scenario: I have 2 databases - Jobs and Contacts. I go to create a new job, and I am asked to choose who the job is for - the contact. I have a list of available contacts which is a portal. The relationship is based on a global number field in the jobs database, which is set to 1 and a match field which is a number (or flag) in the contacts database which can either be '0' or '1' (so that contacts marked as '1' appear in the selection list). I have a filter function so that, say I …

I have two files (Product and lineitems) have a text field that is the basis of the relationship (ProductCode::Linecode). So that a match is made for the portal Dog=Dog. However some of my code fields do not only say DOG but Dog+ or Dog- (indicating dog types etc.). When FM seems to be ignoring the "+" and the "-" and calling it a match on DOG regardless of the + or - . Therefore when I Bring up the Product for for DOG+ The portal lists all the line items for DOG+ AND DOG AND DOG-. Whats up with that???

I CURRENTLY have a PRICE LIST DB that contains about 8 REPEATING fields {200 in EACH}. With the 8th field named [sell Price] I am trying to setup a RELATIONSHIP to ANOTHER DB. The REPETITION in the [sell Price ] field is 64, the value of that is "$50.00". In the NEW DB i am setting up i have a field [Glue] which is the number of [sell Price] items in it, Then i have a CALCULATION field [Total Price]. After selecting the amount of items required in the [Glue] field i want to setup the [Total Price] Field CALC. to MULTIPLY that [Glue} value with the Specific value of the PRICE DB: {Sell Price]. EG. If [Glue] field value was "3" then i want the [T…

EDIT: PLEASE NOTE THERE ARE PROBLEMS WITH ATTACHMENT - A NEW VERSION IS ATTACHED LATER IN THE FILE. Continuing on from previous thread: "one DB with multiple relationships" We have a main database (properties) which has various parties that need to be applied to it in various locations. These parties are either individuals or companies. Some fields will require an entry from either of the 2 party databases (namely Companies and Individuals). Attached is a possible solution that allows for ease of data entry in properties db. If you are interested in how to create a value list that sources data from 2 databases this file may be of interest. …

Hopefully I am posting this question in the correct forum. Not sure if this is a relationship or portal problem. I am trying to filter a relationship so that it only shows a employee working at a site once even if they work there each day of the week. I have the following structure: clients-----workday clients-----schedule schedule ---employee The report prints from the clients file. There is a relationship into workday to get the list of days that need worked. There is then a relationship into schedule to get the list of employees that are working that client. The problem is that if a employee works a site each day of the week it shows their name …

Hi all, Following on form my recent post in the scriptmaker forum about writing a script to create my thousands of fields, I took your advice, took a step back from my solution, contemplated it for a while and have decided to scrap the old solution and start from scratch - but with not long to go till my deadline, I'm kind of panicking a bit now. I have started a new thread for this as it is no longer a scriptmaker query but now more of a relational one. OK - based on your posts and a bit if thinking on part (which really hurt my head!) here is what I think I need to do to solve my problem of several thousands of fields BTW for those who did not see my ot…

I'm hoping this will be simple ... apologies in advance for my learning curve. I have 6 DBs which track commercial real estate. Properties (everything you ever wanted to know about the building or land) is the main file and contains layouts with relationships and portals to ALL the others. The others (again, accessed through portals in the Properties file) are: - Images (you never see this DB except through the portal) - Availabilities (this file sees great activity, because the avail space changes all the time) - LeaseComps (lease deals, when the space is leased) - SaleComps (sale deals, when the prop is sold) AND - Parties (people and compan…

All, After several rounds of downsizing I have been annointed DBA because I don't lock my machine up twice a day. We are a custom manufacturer and need a new quote tracking system. So far I have 4 DB files Contacts(individuals) Companies Requests for Quotes(RFQ's) Line Items The main interface needs to be the Requests for Quote file When I enter a new RFQ I want to be able to pick a company from existing clients or add a new if required. and add new contact for that company if needed. I could create a global key that would show me all companies and allow creation of records however, I see debate over whether or not to allow creation of records t…

ordermain.db5 related to Customer.db5 by customer# Ordermain.dbt related to Orderdetail.db5 by order# when I print orders I want fields from Customer.db5 but there is no direct relationship to get the fields listed. Is there a way to do this?

Sorry in advance. I'm new here from old DOS database. Order Form [order_main] has line detail [Order_lines] that looks up inventory based on item#'s [inventory]. Relationships [order_main & Order_lines by Order#] and [Order_lines and Inventory by Item#]. All I want is to have Order_main list 10-15 Order lines that you enter item#, it brings up description and price, you enter quantity then extensions fill and you go to next line. HOWEVER I need to be able to modify the Description that is looked up from INventory so that the modification stays with the order. I'm told don't use repeated fields, I can't get portals to list multiple lines. My text is Schwartz FM Pro 6…

What I want to be able to do is: have two tables, table2 makes up a value list used in table1. In table2 I have a primary key (some sort of unique number) and a value (the actual value I care about). I would like the value list in table1 to only list the values and not the primary keys from table2. I would also like to be able to add new records to table2 on the fly from table1. Can this be done? If that is too abstract, here is an example of what I'm trying to do: I have two tables contact.fp5 and city.fp5 in city I have a list of cities that can be accessed in a value list in contact. City holds city_id and cityname. The problem I'm having is that I can eas…

Hi all, Running Windows 2k Fmp6 I have 2 databases which are for testing students. Database 1 is for registrations Database 2 contains all the answers to the questions When someone registers on the registrations database, depending on which subject they register for, it goes off to the questions database and pulls in all the answers from the questions database. Now, the problem I have is some subjects have 18 sub-subjects, these subjects can contain up to 30 questions. Therefore, when someone registers it goes off on the relationship and gets data from 540 fields. Once this data is collected calculation fields are performed in the registrations databa…

Order_detail relates to Order_main by Order#. Order_main relates to Customer by Customer# . Order_detail layout shows related Customer# but because it is not directly related to Customer it can not find Customer name. (Customer name in Order_main thru relationship. I know this is simple but I'm lost. Thanks

Dear All, Is it possable to do the following, if yes how? I am trying to build a filemaker database, to be used via the web. This database will have data inported from Sage accountting software (which is really MS Access) and then the user will use the web interface to view information on a job number. Now sage is split into many different tables and queries, I have made loads of extra queries using MS Access to simplyful some of the data. Each MS Access query table has a job number field, what is the best way of inporting this data into one layout that the web interface can see to search for information on one job number. I was thinking of making one …

I am in the process of setting up a costing (labour)sheet but have run into a problem i cant solve as yet. As can be seen in the ATTACHED file, i require the [class] field to have a relationship to the [supervisor] field/s AND the [beltman] filed/s, So that after selecting the [class], and then inputting the hours on the job the costing FIELDS then calculate the {hours*related rate}. Any calc/relationship solutions to this??/ Thnx Corey.... Costing for labour.zip

Hi all, I have an issue I need help with designing. I have a database with three fields: PortID - the actual port id of the actual record PortB - the port this actual port is connected to Now what I want to do is list all those circuit portions preferably in a portal, one by one depending on which circuit I pick. Example: PortID PortB 1 2 2 3 3 4 4 5 5 6 6 - So say I click on the circuit 3-4, filemaker will know that this is actually part of a "bigger picture" and list all those circuit portions mentioned above. …

My client has a pretty normal retail/manufacturing business. They design and build their own jewelry, which they sell. Orders are taken as they come in. Every week they run a set of reports detailing the new items ordered, with a breakdown of all the components needed to build those new items. Invoices -< Line Items >- Products and Products -< join_files >- Components ...where components are several distinct files each representing a well-defined component type: Wires, Chains, Beads etc. They're joined in many-to-many relationships since each finished Product can have many Wires, Beads, etc. and each Wire or Bead may appea…

I hope that someone can help me. I have a database of styles and another of Images. In the style file I have placed a related image field. My problem is when as master user I go to enter a an image there is no problem, but when one of the administrators is adding the image this is done by right clicking the mouse Filemaker opens a dialog to record a sound?:?? I am completely stumped!

I have a file called Price another called estimate and the last one called workorder. The price is shared between the two. What i've come to find out is that when my opening script opens all the file's the three are all there, after I have been in either one of the later two file's, everythings fine. But when I go into the other one it opens another price file. Now i have 4 file's open instead of 3. What did I do wrong??

I am creating an invoicing database and am being told that in order to keep the database from becoming too unwieldy and to keep reporting fast it is best to have an invoices database and a separate line items database underneath it. The issue that I am having is that all of the information we need for reporting is all held in the line items database, so despite setting up the invoicing databases in a hierarchic structure, we still have to run reports on every single line item, which doesn't seem like it would cut down on run times for reports. On top of that, with the product that we sell, it makes the most sense for each invoice to contain only one line item, b…

hello, i have the following simple relationship: file1::partnokey --> file2::partnokey in both files, the match field is a calculation -- partnokey = left(upper(partno),11) --these fields are also indexed. both of the following "parent" records will show the same set of related records from file2: file1 record 1 -- partnokey = 21BAA0001A_ file1 record 2 -- partnokey = 21ZXX0001B_ RELATED RECORDS FOR BOTH file2 record 1 -- partnokey = 21BAA0001A_ / quantity = 1 file2 record 2 -- partnokey = 21BAA0001A_ / quantity = 3 file2 record 3 -- partnokey = 21BAA0001A_ / quantity = 7 …

I have a problem with one of my relations. It's a one-to-many relationship witch presents done items in a CRM solution. The front end field is a indexed calculation [recID|constant] and the back end is also an indexed calculation: [recID|ifItemDone]. When I created the relationship no error message occurred. It is when I'm trying to create a new related record thru a portal that I get this message: "The relationship 'logFuture' not valid and must be corrected before this field can be modified." I've also tried to recreate the relationship and the fields it depends on, but without any change. Am I missing something obvious here or what? Any clues are welco…

Dear All, Is there anyway of linking a filemaker database to fields within a MS Access Database? Thanks BW

Relationship definitions in a multi-user file become corrupted when I attempted to define a new relationship while multiple users were accessing the file... big mistake. Is there anyway to correct this? Currently the system crashes when I enter the Define Relationships screen, showing that a relationship is missing and so is the file. I was running Filemaker Pro 5.0v1 (WindowsNT) when the problem occured. Will be upgrading to Filemaker Pro 6, don't think this will solve the current problem, but maybe prevent it from happening again. Any advice would greatly be appreciated.

Hi, Here's my problem.. The Relationships are as follows: Person.fp5----manyToMany_join.fp5----Project.fp5----anotherManyToMany_join.fp5----Request.fp5 This is working fine but I would like each Person to see any Requests raised against the Projects they are working on in their View. How do I do this. Thank-you FM Daddys.

Hi, I was using filemaker 2.1 on a MAC and recently installed Filemaker Pro 5.5 on my PC. I am just starting to create my database and already I ran into a problem. When I do a lookup for one word in a field of multiple words, I am not able to get the result back. It seems I need to do a looku for the entire text in the field. Let's say the field I'm doing a lookup in contains the following: "Danny Price" I can't seem to do a lookup on Danny itself or Price, I need to do a lookup for Danny Price to get a result back. How can I fix that problem? I never had to specify anything special in FM PRo 2.1. Thanks for your help.

I have a project database and a contractor database. Each project has four different types of contractor (Master Planner, Engineer, Subcontractor 1, Subcontractor 2). Each contractor can be any one (or more than one) of the four types on any number of projects. I need to be able to see: 1) a break down of which project each contractor is on and what their role is in each project. I can do this using a join file that has four different join fields linked to four different portals in the contractor database; one for each type of contractor. What I can't do is display the courses each contractor worked on in one list (portal?). The are broken up depending on the different ro…

I'm having troubles with calculation that cannot be stored (expecially those referring global fields) because they cannot be indexed. If they cannot be indexed they cannot be user in relationships and to populate value lists. (The specific problem I had is that I was unable to populate a value list - for use in a pop-up menu - with a calculation field referring a global) Is there a way to work around this? I created I normal indexed text field and a script that copies the content of the unstored calculation field into the normal field. The list is populated with the normal field and the script is called just before the value list need to be up to…

is that too many? Here's my problem (simplified) Three databases: Exhibitions Artists Works Works is the join between exhibitions and artists. Works are entered in a portal on the main Exhibitions layout Works include name (serial no.) of artist (from a value list based on artists database) Thus: works records include id information on exhibition and artist. What I want to do is to be able to display, in Artists database, some kind of list of the exhibitions in which the artist ist represented. Problem: one exhibition may include one or more works by one or more artists. An artist may have one or more works in one or more exhibitions. …

I'm creating a large building (commercial real estate) database with 5 other related DBs (leasing, sales, available space, etc.). I knew I had to have a separate DB to hold all the building images (sometimes several per property) but I just couldn't wrap my brain around it - the learning curve is steep because I just started with FM, not enough time to learn, just plunged right in. All I could remember was having read: "relationships don't work with container fields ..." Then I read a post from Andy Gaunt and got it to work ... Phew! I still have a couple problems though, because each property can have more than one image, but only one displays on the main property l…

Hi ALl I have 2 files A and B, I make relationship based on ID... In relationship from A to B , I click create new record option. So When I create a record in A, it also creates a record in B . But in certain condition, I don't want to create a record in B even I create a record in A. Do you know a way to achieve it? Thanks Anh Tran

Situation: Tables: contact.fp5 and purchase_order.fp5 I need to be able to select a contact key for the shipto, billto, soldby, etc fields in the purchase order. I have thousands (maybe tens of thousands) of contacts which I can sort through and limit some (only certain people are shipto, only certain people are billto, etc, but it doesn't limit things enough to make it easy to use, there iwll still be a lot to scroll through). So I've seen two main ways of accomplishing this posted to the forum and in example databases. These are: 1) To "go shopping" for a contact (this is my preferred way) by storing the purchase order primary key into the contact dat…

I have a project database that has 4 employees per project. Each employee's contact information is stored in the employee database. This is a simplification but let's say that the employee name is the match feild and there is an email address. In the project database, I have a related email field from the employee database for each of the four employees. (the employee database has just the employees name and email) This works great but now I want to complicate it. Is there a way for me to assign a employee type to each of the 4 employees in each project that will transfer to the employee database AND (here's the kicker) have it fill in automatically? For Instance: …

Hello everybody who read this message. I would like to ask when I make a new record can FileMaker transfer the data from the first two fields to another layout which have a table like excel tables and put it on the correct row and column??? Furthermore how can I make a table or imports a table from excel and FileMaker

I'm creating a database (projects.fp5) that keeps track of my firm's projects. Each project has 16 different vendors taken from a master vendors list (vendors.fp5). I have 16 different layouts in projects.fp5 (one for each vendor) with standard name/address/phone/notes fields. I want each of the vendor layouts in projects.fp5 to suck the address/phone/notes out of vendors.fp5 using the company name as the match field. I have set this up using related feilds from vendors.fp5 for each of the 16 vendors. It would seem that this would work fine if each project only had one vendor. I keep running into the problem that when one vendor is changed it changes all 16 of the other v…

Hi there- This is a similar question to 'losing data', however, I need it to go to the next level. I know for a fact that it is not because I'm entering information in a 'find' or 'global fields', or because someone is deleting information on me, or even because the file is being closed improperly. Like 'losing data', I have a certain amount of records one minute and then less records the next. My database is broken down into 4 different sections essentially: 1. Bridal Couple, 2. Bridal List, 3. Bridal Purchases, 4. Bridal management (letters etc) Bridal Couple being the parent file and the others being the children. (I'm new to this, but I think that is …

Hi again folks, I want to rename a file on the FM Server remotely, and peserve all links, I remember this can be done with Developer (I have Developer). Do I have to actually install Developer Tool on the FM Server, or can I just connect remotely to a file, and rename it from my local machine? Thanks

This might be the dumbest question ever, but i can't figure this out. I store emailadresses in a seperate database (file 2) and made a relation with the main database (file 1) so the emailadress from file 2 automaticly appear in the fields from file 1 when needed. I noticed that FM automaticly opens the file that contains the emailadresses. Is there a way to get data from file 2 without having it opened while working in file 1? I just don't want my users to see this file appear (eventhough it's mimimized) because they have no business there. thanks in advance.

Hi, I have a problem with my current database design. I stupidly made it so the shipping cost field is a simple calculation which just updated whenever anything changed. However, now I want to raise shipping rates. but of course I cannot do this without changing the totals for old orders. I would like a solution which would update the shipping cost automatically whenever: An item is added (via a portal) The shipping method is changed (via a pop-up) Whenever the location is changed (via text fields) I am somewhat flexible on this, those three things are listed in order of importance (the top being most important). As far as I know the only way to do th…

Hi, I have been taking over a Filemaker 4.1 file, which has about 4 users and running on a LAN. Lately, we've noticed that we are "leaking" customers from the customer database, e.g. I've checked the customer DB 3 days ago, 93 names. Today, when I opened an invoice, I've noticed the pull down list on that invoice is missing this customer?? The link to the customer DB is there, the relationship is correct, but the name of that specific customer is gone(although, the invoice info is correct, and still hold this customer as payable). The more bizarre thing is that, the cusotmer DB count is 89, so I lost 4 names. I swear no one has delete any info from this DB. D…

copying a record to another data file #63960 - 04/18/03 12:39 AM Edit Reply Quote Quick Reply I have created 2 different data files: <***> = a button to edit field (***) = the field heres what they look like: #1 COMPLAINT FORM <Complaint#> (5477) <Date> (4/12/03) <customer#> (131316) <customer name> (John Doe Co.) <address> (576 East Ave.) <complaint> (discription) <date recieved> (4/11/03) <send Info to new investigation form> #2 INVESTIGATION FORM <inestigation results> (type in details) <date> (date) <perfo…

I have created a file that contains name fields for all persons in a group. Within this file certain individuals are identified as Registered Nurses or Social Workers. I have a second file that indicates one or more classes attended by persons within the overall body of names from file #1. Some classes are requied for everybody, while others only require attendnce by RNs and Social Workers. The files are related by the person's identity number (which is assigened by file #1). I have been asked to provide an exception report that will show all RNs and Social Workers who have NOT attended one of the classes. This puts me in the position of trying to find records i…

Hi folks, I have two files (tables), A & B. Defined a relation on A:JobID and B:JobID (int). A is the main table where I insert new records manually. Sometimes (but not always) I need to generate a related record in B but I don't know that beforehand (depends on the data filled out later) My question is: how can I make sure that a later generated record in B will have the right JobID to keep the relation valid? Or better: how can I generate a new record in B and set B:JobID from A? I cannot set the related field (in with a script from the other file (in this case A)... tnx Hank

I have a customer that purchases many items. Each time this customer purchases an item his customer_id is on that item. Now let's say that the customer has purchased 3 items and I want to print out a Purchase Order for them. I assign the same Purchase Order number to each item so that I can tell whether or not that particular item has been invoiced. So this is how the records would look. Customer Id Description Price Purchase Order No ---0054--------1 Computer----------500.00-------0123 ---0054--------1 CD Player----------50.00-------0123 ---0054--------1 TV---------------1500.00-------0123 Total Purchase Order = 2050. What I want t…

Hello everyone, I am relatively new to FM and some of the db terminology. Could someone please explain to me the terms "primary key" and "foreign key"? I have gone through many of the forums and seen them referred to. Thanks in advance!

I have encountered two related problems that I can't seem to avoid regarding related files. The first problem occurs when my client renames one of the files in a solution, which renders the relationships invalid. Of course, the client shouldn't rename the files, but there are circumstances when this is unavoidable (as when the MAC OS renames a Windows file to its 8.3 format (anyone know why???), or when a file gets corrupted, and the client recovers the file to the default "filename Recovered" format). When the client restarts the software, Filemaker knows enough to see that the relationship is corrupt, and asks the client to locate the file, which they do. …

I have a question about linking related files. Example: DB1 has primary key ID#,DB2 has primary key LINE#. DB1 and DB2 are related by the DB's ID#. When I'm in DB1 I create record in DB2 by running a script which opens DB2, creates new record and copies ID# in DB1 and paste it in ID# field in DB2. Then i can display related records in Portal in DB!. The problem is if I want to duplicate DB1 record, it will not duplicate related DB2 records. Is there any other way of doing it? How can I copy primary key from one DB to another. I read many posts on this forum and I can't find any answers. Please help!!

I have two tables: -------contact.db---------- contact_id (primary key) note_id (foreign key) --------------------------- -------notes.db------------ note_id (primary key) note_text --------------------------- So what I would like to do is have a unique note record created and somehow get that primary key into the contact table. This is probably an easy to do routine question but I've not been able to figure it out or find any related posts. I could make note_id = contact_id but that will cause other problems for me, I need a unique note_id key. Thanks for any help.

Okay, I will try to explain what I need to do. I know it can be done, but I can't figure out how to make this work. I manage a company that sells children's books to schools (not textbooks). We have a fairly large warehouse and keeping track of all that inventory is a nightmare. I created a FileMaker database that holds all the inventory with descriptions and such. My main concern is tracking quantities so that we don't run out of anything. That part is working fine. This is where it gets confusing: Our best selling products are sets of books. Basically, we take a dozen or so individual books with similar themes and group them into a set. We don't actually stock…

Is it possible to create a relationship that requires two fields to match (in my case 'amount' and 'date', so that a third field's data can be looked up. I tried a calculation (if, test, result 1, result2), where the test was to match amount and date in each respective DB but no result would come up.

Hi guys, -P.S this is coming out in double paragraph spacing, don't know why sorry - makes it look more long winded than it already is I am attempting to create this database, currently the user uses a multitude of separate excel spreadsheets to monitor company. Please tear it to shreds, I have basically made it up as I have gone along and with the hour of night, I have probably not thought through some issues. So constructive critiscism welcome Sorry for the long winded post, but i always found it better to explain first what i am trying to achieve! P.S haven't really done much to layout so buttons may be dodgy.... have checke…

hello im reasonable new with FM but have done some work with Access & lotus Approach i can do most things i want to except this problem i have at the moment i have seen loads of things with simlier problems however i cant seem to find the right answer sorry for boring you all i have posted a few months ago but no one responded previous post. ok there is 3 files involved product.fp5 partslist.fp5 stocklist.fp5 product not overly important however it is the form part & i want the partslist to be in a portal. those 2 bits are easy & work fine i can add parts in the portal parts list file what i want is from a drop down box in the po…

Hi, Here's what I would like if possible: I have been tasked to develop a basic db in FM but am having difficulty doing a basic thing. For example: I am assigning people to a group, so I have 2 tables/files - people.fp5 and group.fp5. Each file uses unique sequenced record IDs. In the people.fp5 one of the fields is groupID. I want to add a person in the people.fp5 and then assoc that person to a group. I don't want to type a number in the people.groupID field, I want to select from a dropdown of groups. OK, simple stuff I know, but how do I do this. The files need to remain relational, can I use a list of group.groupNames in the people.fp5 file? Won't this give …

I'm having trouble getting relationships to work on an invoicing program I'm setting up. The three files are "Invoices", "Customers", and "Products". "Invoices" is the main, and I can use the "Customers" account number to autofillin the pertinent info into "Invoices". The problem I'm having is getting the "Products" to do the same thing. I've set up "QTY" as a "number, repeating", "Item" as "text, repeating, and then it looks up the "description", and also the "Cost". However, as I add more items, it still looks up the "description" but will only look up the "cost" of the first "item". All "repeating" fields are set to 20. I can't figure out why the other "items…

I am trying to create an inventory function where I have a database "products" that contains information on all items purchased including product number, description, vendor, etc. I also have a database "items" that is the main listing of all items/equipment that are purchased. This is also where users would input all the serial numbers, product numbers, assignments, quantity, etc. What I want is to be able to have either a portal or some other mechanism so that when someone is entering data on a new purchased item, once they enter the product number, it is looked up against a matching record entry in the products database. Then all the information for the pro…

I'd like to find a way to have two defined fields act as one primary key. In other words, the two fields together should be unique, not when they are isolated. Background: I have an Employee file, that has an Employee ID in it. I have a TimeCard file, that has an Employee ID (foreign key to Employee file) and a date field in it. I want to collect all the times in the timecard file. However, I want to avoid having Employees make duplicate date entries... Any ideas?

I work for a kitchen manufacture and designed a data base for ordering sample door with custom finish. I have four files the main one has a relationship to the finish data base which stores the finish number, name and formulas. From the main file I created a relationship via a value list to the finish DB Some time when I click on that cell to select the correct finish no. The systems just sits their and spins (think) Some times in a few minutes it will let me enter the finish no. Other time it can take anywhere from 5-20 minutes to finish thinking. Thank You Andy

Hi there, I was quite to the end of it. One of the specificity of my business is that a customer may also be or become a supplier (and vice-versa), as I

Hi, everyone. Here's a question from a newbie. I'm trying to establish a DB which has two elements - a password-protected data entry side, and a read-only record browser. My initial thought was to create the read-only version as a separate copy of the first DB, but with every field as a related field to the data entry DB. This seems like it will take forever, though, to define all of the relationships and then reconstruct in the read-only file. Is there another option available to me? Any help would be appreciated.

As Mark suggested, I'll open a new thread for this problem as I came up with exactly the same proble he encountered one year ago. There is a small attachment in last post of this thread that will clearly show the problem, if you don't mind have a look. old thread from 2002 not solved This very little file has the basics PO-Line Item-Product-Customer files. Items are entered through a portal in the PO. Customer ID an dCustomer Name are lookup but they have a strange behaviour. When processing an entry from the Report PO file, you will notice that the Lookup for Client ID and Name in the Line Items will : - not work if you select the Customer from list…

I am trying to create a hotel assignment system. I have a db of people with hotel request criteria and a db of rooms with potentially matching criteria. Every room has 5 days in the record and every person has 1-5 days requested for room assignment. If the people's request match the hotel room criteria they appear in a drop down menu for that day. That all works fine. What I want to do is have their names eliminated from the menu when they have been assigned a room. I tried... If(HotelRooms::Wed = CompanyLastNameIDCalc, "Yes", "No") Where the relationship "HotelRooms" is based on the match I described above, but the Calculation is too broad and only finds o…

Hi there, Im new at making FMP relational. Im trying to create a database for my research on designed objects. Kind of like a museum/library DB. At the moment I have four main files: AUTHORS.fp5 - Has information on the Authors of Publications and Objects. OBJECTS.fp5 - Has information on designed Objects in the museum. PUBLICATIONS.fp5 - Has information on books etc, published by Authors. QUOTATIONS.fp5 - Has quoted text taken from Publications. These have a number of other minor related files. It seems that I can handle the one-to-many relationships, but Im not sure about the many-to-many. For example: one Author can have many Publications and one P…

hello people! I am sure you have seen this tool http://wmotion.com/visualizer.html Has anyone found it for Windows platforms? has anyone used it for MAc? how is the performance/accuracty? thanx

I am currently working on a Database for my school. I was wondering if someone had advice on the best way to set up a relational database that track and link family members. In my first attemp I created a contacts file with id and family id. I created a self join and put a portal on the student record to show all the related family members. Is this the right way to do it or is there a better way.. say with an additional file. My first DB I had trouble extracting data for example a letter to the parents that contain the students names. I couldn't get three records into one record in the format I wanted...maybe because my initial set up was screwed up. I would much a…

I often find myself using alot of global fields which I really hate doing. I have a Client DB, Proposal DB and Invoice DB. The Client DB is a 1 to many with the Proposal DB related by a clientID. The Proposal DB is related to the InvoiceDB by a Proposal ID. When I want to create a report to print out in a layout in the Invoice DB, I find myself creating a global field in the Client DB and relating that to the proposalID and then creating a bunch of global fields in the Invoice DB which are set to the values of the fields in the Client DB in the script. The global fields are for the first name, last name, email, phone, title, company name, and a lot of the fie…

This maybe easy or hard... I cant tell. In the database I am creating I must take care of tracking specific parts. Therefore I wanted to create a database of just items where each item would be its own record. With this item record would be fields: "Part Number" - (So I can ID the part) "Status" -(where the item is, ON ORDER, IN STOCK, SOLD, ECT) , "PO#" - (So I can look up where it was purchased from for RMA's), "Invoice#" - (So I know who I sold that part to), "Serial#" - (So each part can be tagged with this number" and "Price" ect... Now I can easily create these parts from a sepreate Purchase Order file. What I need to know how to do is; make it so when I add an ite…

Hello FMers! I am creating an inspection photo database for insurance agents. Client data resides in the Clients File and photos reside in the Photos File. Photos is related to Clients and vise versa. Here is the problem: Since a client may have more than one photo, I would like to have one image designated as the Master image. In the Clients File, this would be the image that displays with the client data. I have noticed that the first image record related to a client record will display in the related container. The help file says something about how the first related record will show in a related container, which is based on how related records are sorted. S…

I am new to Filemaker, trying to use it (5.0) to organize the research for my dissertation. I want to make two files. First, one for notes from various sources (one record per source, each record having one large field for the notes). And a second file for particular persons. I want to find a way to have the info in the Notes file on a particular person show up in the record on that person in the Persons file. It seems clear that the person's name is the key. But I could not get FM to index a multiple name, even using the Option Spacebar. Using Option Spacebar, I could get Society for the Diffusion of Political Knowledge indexed as a single phrase, but it would not…

I have a Agent database and another database called "Projects". Each Agent can have multiple projects. I figure this is a one to many relationship. The Agent fields are: agent_id, name, emal, phone, notes, status and some global fields. The Project fields are: agent_id, project_id, name, project_state, cost, date_created. Do I create the relationship in the Project DB or Agent DB. To my understanding, I create the relationship in the Project DB, relate the agent_id of the Project DB to the agent_id of the Agent DB. I wrote a script that creates a new Agent record and calls an external script in the Project DB to create a new record as well. My problem is …

I'm getting spurious results, so I must need a better understanding of Self-Joins. In a database I created a self-join relationship using "Serial#" on both sides of the relationship as Key Field. I have some calculation fields in which I'd like to be able to edit the contents. Hence, a lookup of the calc field should give me the editable calc result. But no. Am I missing something really basic? Grateful for any light, ~Dennis

Hello People! Here is my set of relationship questions I hope you can help: -------Reports.fp5---------------(master) ReportID PO .. ___________________________________ ------Items.fp5------------------(related to Reports.fp5 ReportID PO ... ___________________________________ I would like to have Items.fp5 to automatically insert the same PO from Reports.fp5 whenever I insert PO number into Reports.fp5!The reason being is that 1 PO can have many additional Items that I will be adding later! How to do this? Am I on the right track at ALL? Shoud PO field be a Auto- LookedUp or calculated value?: Thank you guys

I'm having an impossible time getting my head around the theory of relationships. Is there a thread on this forum, or an article, that speaks to the question of how to understand which fields to relate in order to get the results you want? Abbe

Hi, I have a set of three tables: A, B, and C. In A there is a portal showing a relationship between A and B. There is also a defined relationship between B and C. When I am in table A, I can easily create a button to "go to related record" to table B. The table B is displayed nicely. However, I really want to go to the related record in table C, based upon the current value in table B (just looked-up in the previous step). Is there a way to do this? Thanks in advance!! David

*Repeating fields as Keys* I