|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Help! I just normalized my databaseI'm one of those inexperienced database people who ended
up with a d/b with 120 fields. I'm getting a lot of the "Too many fields defined" errors on update. I have researched and now know how to normalize my database. I have many tables now. My database is for customers to track there loan status. It has fields like.. name, address, date of app, lender, appraisal ord, appraisal rec, closing date set etc...... I can't figure out how to set up relationships in Access 2002. Each borrower wil will have a record in all tables. When I use the wizard to set up tables it asks will there be a record in the Borrower Table that matches many records in the Address Table or vice versa. It doesn't ask will there be 1 record in each table that matches 1 records in all the tables. Can someone please help me. I'm very frustrated!
Other interesting topics
ASP and MS Access and Password Authentication
Windows XP SP2 & Frontpage Background sound types or extensions. Front Page & Netscape Compatability - Assistance Please Changing the default Portrait Option When Printing displaying results on web site in frontpage How to hide all the toolbars in a Page? live updates how do I control display settings in FrontPage? Printer Friendly Version Of Page |
|||||||||||||||||||||||