Search results

Hi, Sorry about the vague title, couldn't think of succinct way to describe this... I have a table (tblSample) with the primary key of SampleID. It is the one side of a one to many relationship with tblDetails (foreign key is SampleID) whose primary key is the combination between SampleID...

Hi, I have a report with an option group that links to a field with values between -2 and 2. Is there any way to make an option group with only two choices, one choice is if the value is 0, and the other choice if it's any other value. It seems like it should be simple enough but I've been...

Hi, I'm trying to create a database to keep track of tests. Basically, I want to have a sample on which multiple tests are done, then each of these tests has subtests. When all is said and done, I would like to be able to query by sampleID and find a list of everything pertaining to...

Hi, Table 1: ID (Primary key), a bunch of other stuff. Table 2: ID, Test, Result. Primary key is combination of ID and Test. What I want to do is have a form to input the various test results using option groups for the input. For simplicity, let's assume for now that the...

Hi, I've spent the last few hours searching through old posts so hopefully this isn't already answered somewhere. Anyhow, I have a form whose data source is the table that I want to update. The table consists of 4 fields, ID, First and Last Name, DOB. I have a combo box that looks up the...