If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Your advice for Many to many relain..
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Advice on table setup | Rick Vooys | Database Design | 7 | August 2nd, 2004 11:19 PM |
Garfields macro advice | Mick | General Discussion | 2 | June 23rd, 2004 06:31 AM |
Word of Advice for New Users | Nikos Yannacopoulos | New Users | 4 | May 20th, 2004 11:47 PM |
need help or advice on what to do | help | Worksheet Functions | 2 | April 17th, 2004 12:21 AM |