This topic is 2618 days old. Please don't post here. Open a new topic instead.
I have a layout that uses a portal. One of the items in the portal (Author) is tied to a value list of authors. When entering the previous field and TABbing into the Author field the field contains 'WebDirect-' followed by a hex number, which varies. In addition to that, a dropdown menu appears. If one TABs out of the Author field the 'WebDirect-' with the hex digit becomes the value of the Author field. Attached is an example showing the problem. The default value (when empty) is specified by the Get(AccountName) calculation. In FileMaker Pro 18 my user login name is the default. How can I get web direct to default to the user name?
I have my working solution with 10k+ records within one of the tables field i want to create new table, How can i create new table from already existing field. To clear my point i have made a demo/sample file.
I have a TableA with ID and two fields Person Name and Office Name. How can I make new TableB using field Office Name from TableA and keep the existing records.
OR How can i split TableA into TableB using field Office Name and give it ID/auto enter serial.
Thanks in Advance for any Help.
I’m pretty new with using Filemaker, but still I built a solution that fits pretty all my needs (for now…)
I’m still experiencing one big problem with my solution for which I would need help.
Here’s the context : I run a little company. We receive financial reports every quarter.
All quarterly reports ( Excel file or csv file) have the exact same form.
I then created a layout based on the table created when importing the csv that works properly.
My need: as I’m to receive a new financial report on next quarters (Q12018, Q22018, Q32018 etc.), I would like to pull the new data from my Main layout.
Is there a way of having a layout pull the data from the new table (actually whatever table) to be created each time I’ll be importing a new Financial Report without getting rid of the original data (which I would like to keep in place, for obvious reasons)? Let’s say from a pull down?
Thank you very much for your help and don’t hesitate to get back to me if my explanations aren’t clear enough.
I'd get some problems with date formats after installing FMS 15, and I'm trying to solve it by importing to a clone of the original database. But two tables has no layouts and I can't find a way to import these tables without making a layout in the clone or adding a table when importing. The last seems to be the simplest, but how will the relationships behave?
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!