[access-uk] Re: Access Database Relationships

  • From: "George Bell" <george@xxxxxxxxxxxxxxxxxxx>
  • To: <access-uk@xxxxxxxxxxxxx>
  • Date: Mon, 23 May 2005 22:54:38 +0100

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

Other related posts: