Creating Forms for my home business

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top