Search the Community
Showing results for tags 'id'.
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!
Do folks have recommendation on setting up a system for creating regular, human readable and consumable, IDs with an offline/online-sync and hosted solution? The offline part of the solution allows full creation of new Orders. These Orders will (should? could?) have an OrderID will be visible to the customer and given to them on an invoice at the time of creation in the offline world. (The invoice is generated along with the order and will be emailed to the customer, so the OrderID will be there.) But someone else in a different offline copy, or someone who creates an Order on the server,
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. John
Get ready for a headache! I have this wonderful Finance database that I have been working on (With your guys' help) for quite some time. In this window (Table View) it shows all transactions for a given account. The issue is that the program also manages "recurring transactions" which it automatically creates records for at the beginning of the month. Each record has an "ID" that is a sequential serial added at birth. Problem is, (see picture), when the recurring transaction gets created, it's ID will be lower than another transaction that might occur on the same date,