Recent content by Mythics

I've got a mess of a database containing roughly 30 queries based on around 10 different tables. It's a complex routine for a manufacturing database based on an extraction from their MRP system. The issue I'm running into is that nearly every query refers to a specific field for a certain...

If you pull from a single table/query, here's my suggestion: Add an autonumber field to your table, forcing it to be unique. Add the ability to re-update that autonumber field in case records get deleted, resulting in some numbers no longer existing in your table. After that, refer to your...