Linking to a field in a different table

[AussieNerida via AccessMonster.com]

Hi there,

I have a table that records the names and numbers of documents. Linked to
that is another table that records the details of different versions of the
documents and the type and reason for the changes, and, linked to that is the
actual history of the amendment process for each version. So, for every
document there can be multiple versions and for every version that can be
multiple history entries.

I have developed a form that shows the details for an individual version and
in a subform the history details are displayed. What I'm trying to do, but
can't seem to do, is to display the document name and number on this form. I
can't work out how to link the field that is the DocumentID on the version
form to the related field in the Document details table.

If I use the wizard I get a list of all Versions and if I try to use an
unbound field and link it from the form field to the table field I get #Name
error. I had something like =[tblDocumentDetails]![DocumentID] = Me!
[DocumentID] and then converted the field to a combo box that used a Query
that combines the document name and number.

I hope all that makes sense and that someone has an answer for me.

Many thanks,
Nerida.

 

[Joan Wild]

You can have the main form based on a query that includes the Version and
Document tables; include whatever fields you wish from the Document table.

Another alternative is to create a form (Documents), that has a subform
(Version), that has a subform (History). If you have established
relationships between the three tables in the relationship window, the form
wizard will create this for you. When you are at step 2, choose the
Documents table and its fields, then choose the Version table, and its
fields, and then choose the history table. Then proceed to step 3, etc.

 

[AussieNerida via AccessMonster.com]

Thanks - appreciate the help!

You can have the main form based on a query that includes the Version and
Document tables; include whatever fields you wish from the Document table.

Another alternative is to create a form (Documents), that has a subform
(Version), that has a subform (History). If you have established
relationships between the three tables in the relationship window, the form
wizard will create this for you. When you are at step 2, choose the
Documents table and its fields, then choose the Version table, and its
fields, and then choose the history table. Then proceed to step 3, etc.

Hi there,

[quoted text clipped - 23 lines]

Many thanks,
Nerida.