Search the Community
Showing results for tags 'id'.
Found 4 results
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, even though the recurring transaction cleared the account AFTER the newer transaction. Now to complicate things, the ID is also tied to another table which houses categories, amounts, etc. So to change the ID in this table means also manually updating the record in the other table (Relationship is built on this ID field) The table is sorted by Date first, than ID, in order for it to total correctly, the transactions must be in the correct order. Basically, what would have to happen in this instance would be I would have to update both this table and the categories table to reflect Row 1 being ID 184, Row 2 - 104, Row 3 - 183 as the RED Pending transaction needs to be last on the list. How can I make this work?
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, will also get OrderIDs that might then conflict with each other. How do you reconcile these different creation points? And just using UUIDs isn't a solution; it needs to be something simple that a customer can read off; 6 digit number or some such. Maybe a prefix for each device/salesperson? Maybe try to create and control blocks of IDs that go to each device? Maybe a temporary ID somehow, e.g. a 'purchase order ID' for the offline generated items that then gets translated to a full OrderID when they sync to the server? Then the customer would have an invoice (guess it would be a P.O. now) with one number and an invoice with another. Seems a bit confusing. Anyone have something they have successfully used? Thanks, Justin
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