Recent content by RBarber

thank you. Should they be one to many or just one to one? and should I enforce referencial integrity?

Dear all, i have having such trouble setting up some tables in a new db, and am wondering if someone could give me some tips as I really don't know what I'm doing (I am new to this). I have one main table, called Client Information. The PK is CaseNumber. I also have 11 other tables. The PK...

Hi Neil, thanks for the reply. I did that, but am still stuck (ie, I enter information in the forms, and then I try and run a query or report, and no information comes up, which makes me think the tables aren't all linked together properly). I now have a field called CaseNumber in each...

I set it to no (tried yes, tried no, but still same problem). Actually I have now taken out the subforms altogether - it was making it too complicated and I decided I didn't need them. So now it's all just one form. But still the same problem, I just can't work out how to actually get the...

Dear all, I have a question which I think is probably very straight foward for those who know about these things. I have just created a new database, but there are obviously some problems with the design, because when I enter information into a form, I don't seem to be able to access the...

thanks, but... it fixes the problem, but creates another problem. It's done something to the links between the main form and the subforms, so that when I open a new main form, the subform shows data from what should be an old record. Does that make sense? (basically, I want the main form and...

Hi, I am in the process of creating a new database - I am a bit new to this. I have a main form, which also contains two subforms. The record source of the main part of the form is 11 tables, and then each of the subforms is based on one table each (so there are 13 tables altogether)...