Need subreport on form to show one record

[ZenDiagram]

Hello,

I posted yesterday about not being able to edit my form because it was based on a read only query.

Now that I have my form edit-able again, I need to show fields from other tables on the form.

I made a report with the owner's information. I dragged it onto the form as a subreport. But, the subreport shows all records for each owner. I just want to show one per form.

How can I do this without screwing up my form again ?

Thanks.

 

[Ranman256]

Dragging the table to the form doesn't do it all.
You must set the property of the subForm to show only that master key.
Set subForm properties:
Master form field,
And
Child form field

Then the subForm only shows the records that belong to the master id.
If you only want to see 1 record (in a many record set)
The sub query show be set to :top 1

 

[ZenDiagram]

Ok - I have linked master and Child fields. Now I want to show only one record per owner.

How and where do i set the sub query to: top 1?

 

[JHB]

..
How and where do i set the sub query to: top 1?

In the query "SELECT Top 1 ... "

 

[arnelgp]

did you make the master/child link fields to the Sub Report?

 

[ZenDiagram]

Pat Hartman,

I have tried that but it made the form "read only". Correct me if I'm wrong, but if I make a query that joins two or more tables together as the form's record source, it will make the query un-editable (or "read only").

Also I'm not really sure what a "join" is. Is that when the record source has two or more tables with a relationship?

 

[ZenDiagram]

Here is a photo of the form property query showing the relationships between my tables/ query.

 

[ZenDiagram]

Thanks so much, Pat Hartman. I will readjust.