 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 2005Creating Forms for my home business
I am not sure if I am going about this the right way or if Access is going to do what I think it can do. I have a home business where I get work from title companies and I have different borrowers and different companies that I work for. I want to be able to create various forms where I don't have to keep re-typing in the borrowers names and the companies names, but I want to input an "ID" and the information will go in automatically. Is this possible? And what is the reasons for relationships in access? Create a table for borrowers and a table for companies. Use a combobox or listbox based on these tables to input BorrowerID and CompanyID where you need them. Relationships where referential integrity is enforced prevent you from deleting a parent record when there are child records. For example, you won't be able to delete a Company record if there are CompanyID records. Relationships automatically join tables in queries based on multiple tables. Relationships are needed to create form/subforms and report/subreports. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com www.pcdatasheet.com > I am not sure if I am going about this the right way or if Access is going to > do what I think it can do. [quoted text clipped - 7 lines] > > And what is the reasons for relationships in access? I am in business to provide customers with a resource for help with Access, Excel and Word. Mf fees are very reasonable. If you need help with your database, contact me at my email address below. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com www.pcdatasheet.com > Create a table for borrowers and a table for companies. Use a combobox or > listbox based on these tables to input BorrowerID and CompanyID where you [quoted text clipped - 25 lines] > > > > And what is the reasons for relationships in access? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.