Can it be done in a Form and Subform ?

P

Peter

We are creating a small database with the following tables

Series
File
Document

Series - File is 1 to M
File - Document is also 1 to M

Is it possible for us to create a Form and Subform combination that Series
Table is the Main Form that contains the Series ID and other descriptions.

For the subform, we would like to update File ID, File Description, Document
ID, Document Description1 and Document Description 2.

I have attempted to create a query that contains Series ID, File ID, File
Description, Document ID, Document Description 1 and Document Description 2
BUT find that it doesn't work.

We would like to use this format as end user doesn't want to have another
form to maintain the File table.

Your advice is sought

Thanks
 
T

Tom Wickerath

Hi Peter,

I believe you can find a similar form in the Northwind sample database,
named "Customer Orders". This form displays data from three tables that are
linked 1:M. These tables include:

Customers
Orders
Order Details

The form, as currently shown in Northwind, is read only. However, you can
make changes to the form properties for the main form and the two subforms to
allow edits / deletes / additions. It may take a little tweaking, but it can
be done.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

We are creating a small database with the following tables

Series
File
Document

Series - File is 1 to M
File - Document is also 1 to M

Is it possible for us to create a Form and Subform combination that Series
Table is the Main Form that contains the Series ID and other descriptions.

For the subform, we would like to update File ID, File Description, Document
ID, Document Description1 and Document Description 2.

I have attempted to create a query that contains Series ID, File ID, File
Description, Document ID, Document Description 1 and Document Description 2
BUT find that it doesn't work.

We would like to use this format as end user doesn't want to have another
form to maintain the File table.

Your advice is sought

Thanks
 
Top