[access-uk] Re: Access Database Relationships
- From: "Theresa Hodge" <theresa.hodge@xxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Mon, 23 May 2005 15:37:55 +0100
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
Other related posts:
