We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About NewBoard

  • Rank

Profile Information

  • Real Name
    Von Scheffler
  • Title
    Quality Assistant
  • Industry
  1. Thank you very much Wim! This did the trick
  2. I have a form in which users make measurements of multiple parts, then input the max and min measurements. I then have conditional formatting that compares these maxes and mins to the hard mins and maxes for that part. If the inputted max is larger than the hard max, or the inputted min is smaller than the hard min; the conditional formatting is supposed to highlight that measurement in red. This has worked in almost every case I have tested so far, except for one strange case. I have a hard min of 9.8, and my user is attempting to input 10 as the min. FileMaker is highlighting this in red, even though 10 is larger than 9.8. When we change it 9.9 it isn't red, but 10.1 makes it red as well. I have no idea why this is happening, so any assistance in this matter will be greatly appreciated!
  3. Thank you comment this did the trick!
  4. I currently have a form that contains a portal. In the portal there is a value that will either be "Accepted" or "Rejected". I'm wondering if there's a way to parse through this table to check if any related values have a "Rejected" or if they are all "Accepted". Then using that outcome, decide if the form should display Rejected or Accepted. Please let me know if I need to provide any more information and/or images. Thanks in advance for any assistance you can offer!
  5. Copying associated data between tables

    Oh my gosh. Thank you so much Fitch. You have solved something that I've been stuck on for a few days now. This worked perfectly!
  6. Copying associated data between tables

    That won't work for me unfortunately. I don't have a simple relationship like that. I have Lots, tied to Part Revs, tied to Parts
  7. 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!
  8. Referencing specific data in other tables

    I answered your question. RecordedDimensions
  9. Referencing specific data in other tables

    Your assumption is correct. So, I currently have one form for building the parts. This is where the manager will enter in what dimensions are being inspected, what tools, and the tolerances through a portal linked to the Dimensions table Then, as the inspections are actually performed, they will pull up the following screen: The portal on the left contains all of the information that the manager entered in earlier. I want the user to be able to enter information into the portal on the right, which points to the table RecordedDimensions. Which I have working correctly besides the instrument dropdown.
  10. Referencing specific data in other tables

    A conditional value list is exactly what I'm trying to make. It's a little easier said than done though, since I'm storing values in one table, but referencing them in another. Currently when entering values, my stored values table doesn't know which report from the Dimensions table it's referencing. If I could figure out how to the dimensions and stores values 1-to-1, I could do a conditional value list. I've managed to get the drop down to only show Gage ID's related to the gages used in the inspection. However, it shows ID's from all of the gages used on that inspection. Whereas I want it to only show the ID's for the gage used on that specific dimension. Let me know what I can clarify for you.
  11. I am currently building a database to handle the inspection sheets used by our Quality lab. Here is the relationship layout: For each revision on the Revisions table, I have a differing number of Dimensions that need to be measured (some parts/revs will have 5 dimensions, while others will have 15). Each dimension has a specified type of instrument used in measurement, and a max/min value. The instrument used is a drop down menu that references a list of instruments/gages that we use. Here is how I have my inspection sheet currently laid out: The portal on the left points towards my dimensions table. It shows the data corresponded to the specified Part Number and Revision level. The data contained in this portal is uneditable from this form. The portal on the right points towards my RecordedDimensions table. It will store data that will correspond back to the Lot# associated with that inspection sheet. I also have a table that pairs all the different types of instruments we use, with their corresponding gage ID's: Now I would like my user to be able to click on the dropdown box under Instrument#, and that drop down box will only show the Gage ID's for the specified gage. So, if on the dimensions table, a dimension calls out for Digital Micrometers to be used, then when my user goes to select the instrument ID (which is saved in the RecordedDimensions table) it will would allow them to choose 151, 152, 153, 306, 324, 330, and 331. Please let me know if I have not provided enough information/pictures, I will gladly provide more. Thank you in advance for any assistance you can offer me!
  12. I ended up keeping the customer's their own separate table. However, I linked them directly to the parts list. That has seemed to work as intended. What was the advantage to having the third table joining the two?
  13. Variable number of Fields

    I am designing a database for the inspection sheets used in our quality lab. Each of our parts has a different number of criteria that they need to be inspected for. This ranges anywhere from 5-15 dimensional requirements. I am wondering if there is anyway in FileMaker to display a varying number of both editable and uneditable fields. So for instance if somebody pulls an inspection sheet for a part with 6 different dimensional requirements, FileMaker will only show 6 uneditable fields describing the dimensions in question, and 6 editable fields for the user to type in their measurement. Then, if somebody pulls an inspection sheet with 10 dimensional requirements, it will display 10 instead. Thank you for any assistance you all can offer!
  14. I have to ask, why did you split part numbers and customers? Wouldn't it be easier to have a field for customer within the Part Number table?
  15. Okay this looks like exactly what I need. Thank you very much, you are a life saver! I'm just wondering though, how does the CustomerPartsJoin table know which parts go with which customers? Will I have to manually enter the foreign keys for each on that Table? Edit: I'm actually having quite a bit of trouble with this relational setup. Forms connected to the CustomerPartsJoin can find my customers and part numbers exactly as intended. However, I'd like forms related to Revisions (and Inspections eventually) to have a drop-down menu to pick a part number and customer. Trying to do so yields no desirable results, as all drop down menus I attempt to tie to Customer or Part number are completely un-useable. This is the List View of the CustomerPartsJoin table. I have hidden the Customer UUID selector behind the Customer Name box. I can freely chose customers and part numbers here. This is the form view for the Revisions table. I have tried all sorts of combinations for the drop down menus. I've tried pointing them to the CustomerPartJoin table, pointing them to their own original Parts/Customer tables, pointing them at the UUID of the CustomerPartJoin table. All to no avail. I'm thinking that I'm just missing something very obvious as I'm still new to FileMaker. Or maybe it's not possible to do what I'm trying to do with the current relationship setup.