Associating Forms (2000 (in 2003))

Topic

New Reply

I have a small database where I record documents and who I have sent them to. I then chase people to confirm that they have received them (too often they deny all knowledge of having seen them!!). I have a Documents form where I record how and when I have sent them and another form which shows the recipient and which documents I am awaiting confirmation of acceptance. Sometimes I have to make contact more than once so I want to track my progress.

I have tried putting a button on the recipients form sub form to open a progress form. But I cannot get it to associate itself with the Document and Recipient (though both are available on the sub form). How can I do this please so that when I open the Progress form I can see what atempts I have made previously.

I attach a copy of my database.

Many thanks

Roberta

Reply | Quote

Replies

I’m not clear on what you want to happen. Are you trying to display any records that relate to THIS document ref and allow entry of new progress records? In that case you need a method to link recipient with document, which you have not provided. Since one recipient can have many documents and conceivable a single document could be sent to more than one person, the simplest way to implement this is with a join table that contains one record for each recipient-document pair. The table might look something like this:

DocRecipientID	DocumentID	Recipient
1	1	Francesca Jones
2	1	Thomas Edwards
3	2	Francesca Jones

Is the progress table related to the individual recipient or to the document or to both? You have a field for both DocRef and RecipientChased, which both could be replaced with a DocRecipientID from the join table. Then you can base the Progress for on a query joining the Progress table to the DocRecipient table and the information will automatically be available to you for any and all recipients for a specific document when you open the Progress form.

Reply | Quote

Talk about wood and trees – I was lost in a veritable forest!!!! I had a unique ref on the form – but I just got obsessed with linking the person and the document with the progress report.

Many many thanks – I shall be able to get some sleep before work tomorrow!!!!
Regards
Roberta

Reply | Quote