Just inherited an Access Database that tracks member activity...

Two main tables
1. Transactions
2. Dealer List (dealer code, name, contact info, etc)

Currently users enter directly in the transaction table... causing major accuracy issues. I have created a Form for them to enter transaction information (mbr name, dates, amount, etc.)

The problem... I want to have a field for Dealer Name but need the list to match what is currently in the Dealer List table.

How do reference a table in a Form? List, combo list?