Isn't possible?

[Guest]

Hello!

The situation is:
F_Main based in T_Main with IdSector, SectorName, etc. fields
F_Imgs based in T_Imgs with IdImg, FilePath, FileName, etc. fields
1 T_Main record to many Imgs throught relationships.

I would like:
When to click in any IdSector in F_Main, to open F_Imgs with respective 1st
image os this Sector.

Is it possible in Access2K, please3.
Thanks in advance.
an

 

[Douglas J. Steele]

Assuming the F_Main and F_Imgs are forms, add F_Imgs as a subform on F_Main,
and set the Link Child Fields and Link Master Fields accordingly.

 

[Guest]

Thanks for your reply.
With SubForm I know to do, but the F_Main already is big form with many
fields...
I would like to open another form. Isn't possible, please.
Thanks in advance.
an

 

[Larry Linson]

"an" wrote

The situation is:
F_Main based in T_Main with IdSector,
SectorName, etc. fields
F_Imgs based in T_Imgs with IdImg, FilePath,
FileName, etc. fields
1 T_Main record to many Imgs
throught relationships.

I would like:
When to click in any IdSector in
F_Main, to open F_Imgs with
respective 1st image os this Sector.

Is it possible in Access2K, please3.

Yes, it is possible if you have the appropriate foreign key in T_Imgs
pointing to a record in T_Main, and can define how to determine which is the
_first_ image applying to the T_Main record.

In the Click event of the Control in which you display the Id_Sector, you
will use the statement

DoCmd.OpenForm "F_Imgs",,,<insert WhereConditon>

You will have to construct a WhereCondition argument from data in the active
Record in F_Main. Without more information, I can't be more specific.

Larry Linson
Microsoft Access MVP

 

[Guest]

Perfectly, LL.

Thanks for your solution and sorry for my delay.

an