Sorry John, I was sure I included previous messages. There is only one table, tblCars. That table contains Car Name, Car Number, Type, and Length. I want to be able to return a number based on the car name I choose from CarName. Since there are multiple car names I want to filter the CarName so I can pick a particular CarNumber. That will show up in a report listing, say, 20-30 car names with appropriate car numbers. 10 of those names may be, for example, ATSF, each will a unique CarNumber. I'll try setting up the bound column again.
---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (20)|