Search results

That did it! I'm now up and running, and I can figure out the other queries I need as well now that I know how to do that. Thank you so much! :)

I'm not sure how to do this, and I can't seem to figure it out by reading instructions or the help guides in Access 2007, so any help is GREATLY appreciated. I'm sure it's obvious once you know how to do it. In one table, I have ID#s (in column 1) that are labeled as Case or Control (in...

Thanks pbaldy, I'm trying it out now. Appreciate the help!

Thanks pbaldy, that sounds exactly like what I'm looking for. I'll start trying to read up on those things a bit, then I'll post back with more questions. Would that also work for the multiple orders thing? So I could just keep adding orders to the same master form somehow?

I'm trying to create a form that will let me enter an ID number and several pieces of data (that will all be recorded in table 1), and then let me record orders for this ID number (but in a separate table, table 2). I then wanted to see if there was some way to make a check box or something on...