If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Form - Default View

At least I think this is about the Default View...Here's the scoop:

I have three tables: ProjectMain, ProjectContacts and Contacts. The ProjectContacts contains two fields: ProjectID and ContactID. I have a relationship built between ProjectMain and ProjectContacts and between ProjectContacts and Contacts.

From the ProjectMain form I want to open the Contacts form and display the all the Contacts for the Project. I have the Where clause of the OpenForm method set up like this:

When I use this in an SQL Statement like:
Select Contact.Name from Contacts
Where ContactID IN (Select ContactID from ProjectContacts Where ProjectContacts.ContactID = 2)

The SQL returns all the names for the project. When I try and open the form with the Default View set to Continuous Form, only one appears. Is there a way to get all the names to appear on a single form ?

BTW, it worked properly when I had the ProjectID in the Contacts table and just had to join the two tables, but that doesn't work for my data requirements.