Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Associating Forms (2000 (in 2003))

    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

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Associating Forms (2000 (in 2003))

    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:


    <table border=1><td>DocRecipientID</td><td>DocumentID</td><td>Recipient</td><td>1</td><td>1</td><td>Francesca Jones</td><tr><td>2</td><td>1</td><td>Thomas Edwards</td><td>3</td><td>2</td><td>Francesca Jones</td></table>

    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.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Cheltenham, Gloucestershire, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Associating Forms (2000 (in 2003))

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •