I have a database that I'm using for our inventory. I want to be able to autopopulate several fields when I select the computer model. I also want the division field to be autopopulated when I select the branch.
Thanks in advance.
Novice
Windows Vista 
Access 2007
I have a database that I'm using for our inventory. I want to be able to autopopulate several fields when I select the computer model. I also want the division field to be autopopulated when I select the branch.
Thanks in advance.
Administrator
Windows 7 Access 2007
That is what queries with Joins are for.
Novice
Windows Vista Access 2007
Can you expand on what your talking about and how to set them up?
Administrator
Windows 7 Access 2007
When you join two tables that have a relationship, then you can treat each field as if it is in the same table and they automatically populate. Do your tables have their relationships defined yet? Are you using PrimaryKeys (AutoNumbers hopefully) and ForeignKeys (Long Integers hopefully)?
Auto populate form using combo box
Auto-populate form question
Auto-Populate Combo box
Posting Permissions
Reply With Quote