Jump to content

Search the Community

Showing results for tags 'tables'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris Platform
  • Community Resources
    • Community Videos, Tips, & Techniques, Articles.
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


  • White Papers
  • Infographics
  • Samples
  • Add-ons
  • FMGo
  • Solutions
  • Tutorials
  • Plug-Ins

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

  1. I have a TODO list. Some tasks I want to put off until tomorrow, but have them re-appear on my TODO List the following day. I have two tables; TODAY, and TOMORROW. I can get the individual records to go to the TOMORROW table ok by just using a button and script. This operates on only one task at a time. I am having problems getting the records in the TOMORROW table to automatically come back to the TODAY table the following day. I date the records going to the TOMORROW table and have tried to use this as a criteria to send them back to the TODAY table. One problem is that there are
  2. Hi, I would like to know if it´s possible to create memory tables within Filemaker and how. I saw in a different RAD tool the option to create memory tables. The table is kept meanwhile the program is open and dismissed after is closed. I see this as a powerful tool for complex reports and to speed processes. Maybe there is an ODBC or JDBC driver for memory tables, Server side or client side.
  3. I have a table that contains dimensional data for parts. Each record has a unique ID, but also has another field with the ID associated with the part. I have another table that I'll be storing individual inspection data on. I was wondering if it's at all possible to parse the first table, and copy over all records that have a specific part ID to the second table whenever someone starts a new inspection record. Please let me know if I need to provide any more information and/or pictures. Thank you in advance for any assistance you can offer!
  4. Hey, I have a Tab-Separated Text File which I want to import to a database that I just created in FileMaker Pro 15. The text file essentially is a log of events, for instance, one line describes an order, another line describes a payment that has been made. The problem is that I somehow need to import all these lines into different tables. I want all lines in the log file that describe a payment in a table called Payments, and all lines that describe an order in a table called Orders for example. I'm just starting out with FileMaker so forgive me if there is an obvious solution that
  5. I have a db with two tables: 1) Company_info 2) Contact_info. I would like the ability to create new contacts while in the Company_info table. I set up a popover button in the Company_info table to do that, but it only creates a new record in the Contact_info table without any related data. When using it to create a new record in the Contact_info table I can't figure out how to make it copy over the "Company_name" field to the new record in the Contact_info table. The two tables were set up with a one to many relationship connecting the two IDs. (The first ID value is "Comp0001" for the C
  6. Is there a limit to how many fields a table should have? My solution requires the management of 6 categories. Each category has up to 34 sub-categories, although most have 9-12, and each sub-category has several items requiring data entry. This leads to 91 sub-categories and hundreds of fields requiring data entry. The records per sub-category require relationships to corresponding sub-categories that respond to the data recorded. It is like a question/answer system, so the initial question field has data entered that requires answers entered and/or available (from previous experience) in
  7. Hi All, I would like to create a button that copies data from specific table and fields to other ones on display in my form. The context for this is that I am creating a button that copies data that has already been entered and displayed in some text merge fields. i.e., Account address (first table), and I would love to have that data copied to the location address fields (second table). See attached file. Any help would be gratefully received (Complete beginner). Cheers, Simon DB_SC_Grab- button question.tiff
  8. I am working with a Woocommerce installation and trying to create a product form interface. Woocommerce stores product attributes as meta_key's and values. I was wondering if there was a way of linking the table to a different table which would be more manageable and easier to use. Below I have tried to illustrate the two different tables and was wondering if there was a way of linking them together allowing them both to update when information is entered. I have a feeling I might need to use global fields and calculations. However, not completely sure if it is possible.
  9. I have a table which is related to another one. Trying to keep it simple lets say one is a table of cats (first table) which has fields for cat species, colour, weight etc. I can also record the details of when I bought the cat, price paid etc. It is linked to another table where I record all the prices of cats I can find (second table) and they're matched according to species and colour. I create a report based upon a time period using the first table and by doing a find of records which match certain criteria I wish to includewhich shows certain data for example: min price, max price, a
  10. Environment: Windows 7 with FileMaker Pro 14. I have a test database that I am currently making changes to. I saved the test database as a clone, so that I could test importing data back into it. the Import functions allows me to import the first table of information just fine, but it will not let me import any other tables. On any subsequent import, I can select the source table from my source file, but all of the target files are grayed out, except for the first file to which I was able to import into. What am I doing wrong? I will need to do this on a regular basis, as I will us
  11. I have a layout based on a particular table with fields from a table in another file through a relationship - I have full access and hence can access and edit fields, other user with custom privileges are unable to access or edit this fields, but can create records, i have tried editing the privileges on this tables for this users but still no change - what could i be missing? The table name is Rental_Calc, i have attached screenshot for the set privilege. Thanks for your help! Miss A!
  12. Hi, I'm developing for a service company that has a telesales and a field sales team. They then have a service team that visits customers and services products on site. Question: Both prospects and customers are currently in a table called 'companies' and have a simple flag (dropdown list) to indicate the difference. Challenge is that the table has grown to 124 fields with some of the fields only relevant to either Prospects or Customers. Remarkably I have never needed to create 1:1 relationships in such a scenario but I'm thinking of doing so. Would it be advisable? I'm thinking speci
  13. I have been requested to produce a report consisting of Employee Names, each with the single task assigned to them. I have a large DB table ALL_TASKS where each record is a unique TASK_NUMBER, and each record has an employee assigned to it (EMPLOYEE_NM) from a value list (unique values from the field EMPLOYEE_NM). There's also a lot of other summary data assigned to tasks, like time to complete, etc. (Tasks are added sequentially all the time throughout our work day). So far I created a new empty table for my report, REPORT_SUMMARY, where each record will be an employee name, with TASK_NUMBE
  14. I am writing a database to gather information on student's degree pathways. I have 4 years of intake; 2011 - 2014; the discipline - maths, arts etc - 7 choices; then the subjects they have completed or are completing. In total this is 900 fields. This tool is not for official records; it will be used to calculate which subjects certain students still need to complete. So record numbers will not be large. My question is this: should I break up the table into years? This is the way I am planning to design the file: a student will login in via IWP (moving to 14 eventually) then select a year and
  15. I have 24 layouts that are populated with fields from multiple tables present in the relationship graph shown in the image below. (I realize this is not uncommon.) Is it possible to determine which layouts use each table? In other words, is it possible to identify which of the 24 layouts have fields from the table "Contacts", which of the 24 layouts have fields from the table "Contacts 3", which of the 24 layouts have fields from the table "Customers", etc.? Thanks! Joe
  16. Hi, I believe I'm having a problem with an unidentified key concept. I hope to get pointed in the right direction. I am attempting to build an English horse racing form here in Tokyo. I import all the data from Excel and am working from a single table (I believe this might be the root of my problem). I did a few tutorials and I felt pretty comfortable with the basics. At my first attempt (and I thought it was strange at the beginning), I gave every piece of info that would appear on the form its own field. With a possible 18 horses running in a race, and 5 lines of past performanc
  17. Are there any drawbacks to creating a second occurrence of a table? I have hunted around through documentation and help and I can't find a concise discussion of what the negative impacts of it might be.
  18. Hope someone can help. I have a number of related tables. Companies Company_addresses Personnel Personnel_addresses Companies relates to Personnel and Company_addresses Personnel relates to Companies and Personnel_addresses Company_addresses relates to Personnel_addresses (sort of) The intention is to have unlimited addresses for both companies and the personnel related to those companies In the companies' form layout I have a portal that shows the related personnel. This relationship is based on a company_ID key. In the companies' form layout I have a portal that show
  19. My first post here from a relative novice, so I apologize is this is a dumb question or one that has been covered many times. I'm starting to build a database for an academic department, to keep track of contact information, as well as publications, grants, applications, and other items associated with the different department members. Department members can be one of several different positions or "ranks," such as faculty (professors, associate professors, etc.), post-docs, grad students, staff etc. I also want to keep track of the relationships between these various department members, fo
  20. Not sure if this the right place but was curious about people's thoughts on specialized tables versus multi-purpose tables. For example, let's say you have a database with a number of different tables (Table_A, Table_B, Table_C, Table_D) Table_A needs to have a many-to-many relationship with Table_B, as well as with Table_C, and with Table_D so it needs a join table between each of them. In the past, I would create three different join tables, each for the specific join relationship (Join_AB, Join_AC, Join_AD). The only fields in the Join tables would be its own primary ID, Table_A's f
  21. Hi - I'm new to FMforums, but have been reading in here for some time. My challenge is a database, where I need to display some points earned by members in different categories and display their individual points so far - and finally have a tab/layout/button, where new records of points can be entered Plz find file attached. Any help will be appreciated Martin TølbøllClubPoint-vers.-2013.11.05.01.zip
  22. I have created a basic Contact-> Order-> Line Item <-Inventory database but am at a loss how to go about creating the next stage. Our company signs out equipment to its employees. Each Order can be made of multiple individual items from our inventory. This is basically your typical Invoice solution except we are not selling items, but rather signing them out. The trick is how to assign individual Inventory items to a “Kit number & category which then can be pulled up in an Order portal. Once that Kit number is pulled up in the portal, the line items automatically become
  23. I everyone, I'm brand new to the FileMaker database but have some FB experience and a newbie here. I'm well into a heavily modified starter solution for asset management and have been asked if FM will do something! What I need to do is every time a assets mileage or hours is changed in a shared field of "current hours" have it recorded in a table that can then be reported from with a time stamp for each change to the field and it's value. Could someone give me a bit of advice? Thanks always in advance, Jay
  24. I thought I understood that different table views are simply that - VIEWS into the same table, like when you establish a self-join on a key and FM creates a new view for that table. I also thought that data in a field in a table is the same data, no matter which view I am using to display it. Extending that, if I enter or change data in a field using one view, that field will reflect the change to that field in any other view. Now, I understand the concepts of filtering and lookups that might change WHAT you're viewing or HOW you're viewing - but not the DATA itself.
  25. I have a database that keeps growing larger and larger (the number of fields, not the number of records). I want to reorganize before things get out of hand, but I don't know if I should create related tables for different categories of information or if there is a better solution. The main content of my records comes from an outside source, which sends me an excel sheet with applicants for the program where I work. This is all demographic information and contact information. Next, I begin analyzing applicants, and marking the applicants in various ways, creating new fields
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.