Display Form as Datasheet with many-record queries?

[CrystalSurfer]

I want to build a form for my users to allow them easy access to data shown in datasheet or continuous forms view.
However, the problem is that they want to also see on the same form Contact details (Name & Tel.no). This is a one to many relationship with the underlying query so I cannot build this data into that query as it then makes it un-updateable.

I had thought of putting the contact details into a subform and then putting that onto the continuous form but Access does not allow that.
I am currently trying to get it work using an Unbound listbox and then using either a query or DLOOKUP but so far I cant get it to work.
It seems to be something to do with it being on a continuous form.

Any ideas please?

 

[CrystalSurfer]

btw, the Contact I want to display on the form is just one record (the 'Primary' contact) for a company, and there is only one primary contact per company.

Using the following query as the row source for Contact, I get the same name appearing on every company record:

SELECT qryContact_FirstPrimaryContact.Client, qryContact_FirstPrimaryContact.Forename, qryContact_FirstPrimaryContact.Surname, qryContact_FirstPrimaryContact.Phone1
FROM qryContact_FirstPrimaryContact
WHERE (((qryContact_FirstPrimaryContact.Client)=[Forms]![frmClientDSF_Summary].[Client]));

where [Forms!frmClientDSF_Summary.Client] is the key field on the continuous form.

I may be missing an easier idea here but I am a bit stumped on how to display the data.
Thanks.

 

[Fear Naught]

This sounds like you need a main form with the contact details and a subform with the data relating to that contact.

HTH

 

[CrystalSurfer]

thanks for the reply Kevin.
Unfortunately I haven't been clear about what I wanted. This is what I want:

<Company name> <Primary Contact name> <Contract Date1> <Contract Date2> ..
<Company name> <Primary Contact name> <Contract Date1> <Contract Date2> ..
<Company name> <Primary Contact name> <Contract Date1> <Contract Date2> ..
...

The <Contract Date> fields are 'milestone' dates and I want them updateable as this is a nice summary datasheet to work with when chasing clients, etc.

The Company to Contract is a 1 to many relationship but the underlying query selects only the 2007 Contract record for each Company. Hence there is only 1 record shown per Company.

The Company to Contact is also a 1 to many (but also selecting only a 'primary' contact) but is there an obvious reason why I can't add the Contact fields to this continuous form and still have the Contract Date fields updateable?

 

[Fear Naught]

I suggest that you post a cut down version of your database and I will have a look at it for you.

 

[CrystalSurfer]

Kevin,
thats very kind of you. I have some major deadlines at the mo so I'll try to get a cutdown version as soon as poss.
Thanks

 

[Fear Naught]

Hi CrystalSurfer. Have you managed to get a cut down Db for me to look at yet?

 

[CrystalSurfer]

No, unfortunately not
but today the main user said he is happy with not having the contact details displayed as I gave him a double click event that take them to those
thanks anyways.