This topic is 2526 days old. Please don't post here. Open a new topic instead.
I have a field, item ID, set to auto enter a serial number and validation set to not empty and unique. If the serial number entered is not unique I do not get an error message when exiting the item ID field. If I turn off auto enter serial number and manually enter a non unique item ID, I do get an error message when I exit the field.
With auto enter a serial number turned on I only get the non unique error message when I commit the record. I would like to get the error message when exiting the field when auto enter a serial number is turned on
Hi - OMG, I am at the end of my tether on this. Any help would be so much appreciated. It's probably an easy fix. Basically, I have a big database with a Company table and various linked tables (contacts, products etc.). It works well, and all the data is already populated, BUT I did a dumb thing on set up: the table relationship match field is the Company Name, which means if the company changes its name I cannot change the Company Name field as it is a match field (the portals on Company table layout just go blank as there is no match). I did a workaround (two name fields), but what I really need to do is have a unique ID (auto enter serial number) for the company table and just link it to the other tables.
So I created a unique Company ID in the Company table, and have popiulated this with an auto enter serial number - fine - and then as per FMP's website I add a "Company ID" field to the Contacts table. But it does not populate or link. And I see in the forums/online that this works for NEW records I add. But I have 3000 existing companies in the database. I have tried several things but I just cannot get it to work. The Contacts portal on my Companies layout never displays anything. When I view Contacts in table layout, Company ID is always blank.
Thanks in advance for any help.
By Capt JB
I've no programming background, so I am asking for help .
I have a text field with an automated serial number of three digits by increment of 1. This serial is part of an ID number that includes the current date.
I am trying to have this serial returned to 001 at midnight, meaning that every single day the serial starts at 001 up to maximum of 999.
My problem is I cannot have the serial reset to 001, unless I do it manually.
Any help will be very much appreciated
If there is a link available so I can learn basic programming instead of sucking knowledge, it will be very much appreciated too, and I would feel better.. TIA
I am trying to create an autogenerated Id number for an invoice but this number must be prefixed by the year for example 2012/1 however at the start of each new year these number need to go back to 1 so for example the first invoice next year will be numbered 2013/1. can anyone suggest the best way for this to be done.