Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Posts
    115

    Unanswered: One record for multiple records

    I have a database that keeps track for all properties I'm doing a
    title search with the folowing tables.

    I have a database that keeps track for all properties I'm doing a
    title search, with the following tables.

    tblMortgage tblMortgageSatisfaction tblSatisfication

    Fields for tblMortgage
    MortgageID - MortgageName - MortgageDate

    Fields for tblSatisfication
    SatisficationID – SatisficationName – SatisficationDate

    Fields for tblMortgageSatisfaction
    MortgageSatisfactionId – MortgageID – SatisficationID


    The table tblMortgageSatisfaction will resolve the many to many relationship between tblMortgage and tblSatisfication.

    When manually entering the information into the tables, it seems to be working fine. However, I really need help on creating the data entry form for the Satisfactions.
    (Like how to enter the second mortgage for the satisfaction #1)

    If any one knows of a sample database with such an example, can you please share it with me?
    I didn’t find any example when searching.

    Thanks in advance
    Last edited by Tommiller; 07-30-04 at 14:05.

  2. #2
    Join Date
    Aug 2003
    Location
    Cleveland USA
    Posts
    184

    Lightbulb how about subreports?

    If I understand your question, I think you need to have mutiple grouping levels in your report, and one of the groups need to be 'mortgage'. For that grouping level, add a subreport that lists 'satisfactions'. The same satisfaction should be able to come up more than once if more than one mortgage applies.

    If this doesn't make sense, maybe you can post how your primary and foreign keys work?

  3. #3
    Join Date
    Jan 2004
    Posts
    115
    Hi Lisa

    You understood my question. However, I missed a very important point
    A mortgage can be satisfied more then once. How do I handle this?

    Thanks again

    Tom

  4. #4
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Yea, sounds like we need to see your field/names. Also, sounds like a satisfaction can be associated to many mortgages which could possible indicate using two fields to create a "PK" or unique entity. Like MortgageID and MortSatisfID, especially if you are using a subgrouping to make it easier.

    So, reveal your fields, pls.

  5. #5
    Join Date
    Jan 2004
    Posts
    115
    See the next reply
    Last edited by Tommiller; 07-30-04 at 14:06.

  6. #6
    Join Date
    Jan 2004
    Posts
    115
    I changed the original post, and added more clarifications
    It reads like this.

    I have a database that keeps track for all properties I'm doing a
    title search with the folowing tables.

    I have a database that keeps track for all properties I'm doing a
    title search, with the following tables.

    tblMortgage tblMortgageSatisfaction tblSatisfication

    Fields for tblMortgage
    MortgageID - MortgageName - MortgageDate

    Fields for tblSatisfication
    SatisficationID – SatisficationName – SatisficationDate

    Fields for tblMortgageSatisfaction
    MortgageSatisfactionId – MortgageID – SatisficationID


    The table tblMortgageSatisfaction will resolve the many to many relationship between tblMortgage and tblSatisfication.

    When manually entering the information into the tables, it seems to be working fine. However, I really need help on creating the data entry form for the Satisfactions.
    (Like how to enter the second mortgage for the satisfaction #1)

    If any one knows of a sample database with such an example, can you please share it with me?
    I didn’t find any example when searching.

    Thanks in advance

Posting Permissions

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