Please help to link 3 tables

  • Thread starter Thread starter Serg
  • Start date Start date
S

Serg

Hi everybody,



There are 3 tables in a form - a table A, a table B and a table C. The
table A is a record source for the form. The table B is a child of A; the
table C is a child of B. I can easily link tables A and B using the standard
properties menu and choosing link child fields and link master fields. But
please help me to link tables B and C, because if I use the properties menu
I can only link tables A and C .



Thanks,

Serg
 
Hi Serg,

you have two options

1. embed sub form C in sub form B
2 in the OnCurrent event of subformB update a control on form with the value
that is stored in C as a foreign Key. Then link subformC to the control on
formA
 
Hi Stewart ,

Thank you a lot for the quick answer. But i forgot to point that i don't use
any subforms. I only have one main form and a sourse for this form is the
table A. I put in the properties tables B and C their own sourses. What do
you think could I do in this situation?

Thanks
Serg
 
Serg,

I'm a bit confused, do you need want to see all three tables in one form?
Do you mean that you dragged the tables B and C straight onto the form?
What property did you put tables B and C in?

Stewart
 
It would probably also help to know what is the relationship between the
three tables.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Stewart,
I am so sorry for my poor explanation. But I am a novice in Access. At
first, i drugged the subforms onto the form. After this , in properties of
these figures, that i could see as two squares on my form , i changed sourse
objects from " A subforms" and "B subforms" to "Table.B" and "Table.C" . I
always do this way because i dont like subforms look like. After i can
delete these subforms from the list of forms.

Thanks,
Serg
 
Serg,

I understand now and unfortunately I can't see anyway that you can do what
you want with just tables inserted in the form.

Sorry Serge.

Stewart
 
Hi Stewart,

It's ok. I appreciate your help very much. I have some new good ideas now.

Thanks,
Serg
 
Back
Top