Hi Theresa, That's good news. As they used to say on the "A" team, "It's good when a plan comes together" George. -----Original Message----- From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Theresa Hodge Sent: 23 May 2005 22:43 To: access-uk@xxxxxxxxxxxxx Subject: [access-uk] Re: Access Database Relationships Hi George I've sorted my last problem. I had designed a tabular form and the field labels had gone into the form header with the actual fields in the main area of the form. I thought I had moved the field labels to the main area, but had for some reason moved the actual fields into the form header. This was why I could only see one record in the form - because that was all that could be dpiplayed in the header space. So I 'vemoved everything to where it should be and it's all fine. Thanks. Theresa Hodge theresa.hodge@xxxxxxxxx ----- Original Message ----- From: "Theresa Hodge" <theresa.hodge@xxxxxxxxx> To: <access-uk@xxxxxxxxxxxxx> Sent: Monday, May 23, 2005 3:37 PM Subject: [access-uk] Re: Access Database Relationships Hi George I realise that I hadn't been ticking the "Enforce referencial integrity" box - once I did this the relationship looked like all the others. The next problem is that I know there is more than one record already entered in the Enquiries table but it doesn't show up on the form. If I look at the Enquiries table it shows that there are three enquiries for ID 1, but if I go into that person's record it only shows one. In the properties, I have set it to cycle All Records, so I'm not sure what I'm doing wrong here. Theresa Hodge theresa.hodge@xxxxxxxxx ----- Original Message ----- From: "George Bell" <george@xxxxxxxxxxxxxxxxxxx> To: <access-uk@xxxxxxxxxxxxx> Sent: Monday, May 23, 2005 10:43 AM Subject: [access-uk] Re: Access Database Relationships Hi Theresa, What exactly is it that you cannot do? Or is it just that you can't remember what do did before? George. > -----Original Message----- > From: access-uk@xxxxxxxxxxxxx > [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Theresa Hodge > Sent: 23 May 2005 09:50 > To: access-uk@xxxxxxxxxxxxx > Subject: [access-uk] Access Database Relationships > > Hi All > > I have an urgent enquiry about creating relationships in Microsoft > Access. > > I have a main form where I enter contact information about > customers. I have a sub-form where information should be entered > about enquiries they have made. I want to create a > relationship where one client can make lots of enquiries. I > have successfully managed to do this with other sub-forms, > but can't seem to do it with this one - I'm obviously doing > something wrong sometwhre. > > Can anyone help with this? > > > > Theresa Hodge > theresa.hodge@xxxxxxxxx > > > > > ** To leave the list, click on the immediately-following link:- > ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] > ** If this link doesn't work then send a message to: > ** access-uk-request@xxxxxxxxxxxxx > ** and in the Subject line type > ** unsubscribe > ** For other list commands such as vacation mode, click on the > ** immediately-following link:- > ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] > ** or send a message, to > ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq > > This Message has been scanned for viruses by McAfee Groupshield. ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq This Message has been scanned for viruses by McAfee Groupshield. ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq