Recent content by Magger

thank you both for your support. Your ideas have resolved my issue. I now look at the table as disorderly and presentation layer is where the order is invoked. Thankyou!

Hi gurus, I have a access database frontend that books in laboratory samples. The booking system create records for the sample. The sample often has multiple replicates. During record creation, I have found (not very often I might add) that on occasion the records entered don't start at 1...

thankyou all for your contribution. I'm still reviewing all your comments and will get back to this thread, just swamped at work atm. regarding test results. I wanted them in groups, as 1 test even has multiple "observations" that needs to be recorded. ie imagine you had a sample of oranges...

thankyou @arnelgp, I do have some records, but much of what I'm discussing above are new concepts and the current records don't have such data or context. I'll have to read up on normalization. Thankyou for your suggestion.

Hi @GaP42, Thanks for contributing. I'll try and respond to your points below: 1. I just wanted to track an employee who conducted the testing of an individual sample. Later, may help identifying an employees throughput or maybe where an employee is making errors. 2. Later, an employee may also...

wow. Thankyou so much @plog. Just reading your response things seem a little clearer to me. Can see years of experience there. Wow. I've tried to translate what you have mentioned into an updated ERD. I think I've got it correct, but feel free to point anything out thats not correct. Couple of...

BatchNo: I forgot to mention, the "BatchNo" is received from the client and is alpha-numeric and logic changes from client to client. It is however usually unique but could be a chance it isn't I guess. SID: The Sample ID (SID) is a number, also from the client and is usually a...

this is what I have so far. :cry:

Hi, I'm fairly new to accessdb. I am trying to build a db in access based on my use case and getting completely stuck. I'm having trouble translating my requirements into a bunch of tables and relationships. The easy stuff seems to be ok, but I'm really getting stuck on the tricker parts of the...