subform

[molen malat]

I have a Form with SubForm .
how can i look for a certain record(main form) with all its related records(subform )

[NeoPa]

I have a Form with SubForm .
how can i look for a certain record(main form) with all its related records(subform )

The easiest way is to use the Form Wizard to create one based on an updatable query built linking both tables.
Selecting individual items can be done with the main form's Filter property.

[molen malat]

I have this problem:
I have a drug (in the main form) and its components (in subform)
i need to find the similar drug to a certain one.

[NeoPa]

How can we help you?

[MMcCarthy]

I have this problem:
I have a drug (in the main form) and its components (in subform)
i need to find the similar drug to a certain one.

What criteria are you using to find 'similar drug'. Is it a name comparison or something else?

Mary