Search results

I have a list of companies who have corresponding id numbers. Each company name is unique, but may have more than one id number. I have one tabe, osi_name, that is an autonumber and the company name I have another table, osi_no, that is 2 fields, the first field, key is tied to the autonumber...

Thanks for the hint to look into the cascading combo boxes. Also, I agree that the way I'm going about the design part of this particular database isn't going to be the optimum. But they really just want to be able to scroll through/search a list of contact information and notes and pull a...

I'm sorry if I'm asking relatively simple questions. I'm a break/fix guy, and our in house programmers told us it would be 6 months before they could help us out, so we're tackling this chore ourselves. We have a database of company names along with corresponding contact information. Each...

I figured out where I was going wrong. By not selecting an automatic ID key to be made, it allowed me to have the outome I wanted. And since that isn't a requirement for what I'm using it for, I'm a very happy guy. Thanks for the help!

That seems like such an easy solution! Thanks! But when I tried it it doesn't seem to work. Steps as follows: Using Access 2003 Built sample table, approx. 5 names, 10 entries, 10 distinct numbers. Built a form, added a single combo box. pulled "name" records from "table1". Went into the...

I'm a relative newbie to the more advanced features available to Access. If someone could help me or point me in the right direction, I'd really appreciate it. I have one table that contains companies and associated contact info. Each company can have more than one unique number ID (3 digit...