Search results for query: *

I know that databases are to minimize duplicate information or whatever, but i have a field for supplier and a field for manufacturer and 1 time out of 500 it is different. Is there maybe a function i can use in default value, or something so that i don't need to add the same name twice? Any...

How would i create a drop down search box that pulls down all the options for two fields as you rite them? Ex. On the top of a form a box that says search supplier and as you type "fi" and it is showing underneath firefox, film store and fire station.

Hey, so i have been working with the assets template given by Microsoft for the last while now, and have added a table and a few fields. As i was doing this, i realized to add fields to the search, go to the macro filters - > quick search section -> Assets table section, and then just copy a row...

my bad, but lets not worry about that, what did you mean by your post on that other one?

Every time i try your iif function it just deletes it? what do i put for row source type? arghh.. so frustrating.

SELECT [Contacts Extended].ID, [Contacts Extended].[Company], [Contacts Extended].[Contact Name] FROM [Contacts Extended] ORDER BY [Contacts Extended].[Contact Name]; Is what was there, when i try the simple combine, it just gives me the id, which was an autonumber for the primary key.

I am trying to display both the company name and the company name in the record for the "owner" field of an assets database. I have some customers who are a company and contact person, but the problem is the residential customers are only a contact person and no company. The list displays both...

I am trying to display both the company name and the company name in the record for the "owner" field of an assets database. I have some customers who are a company and contact person, but the problem is the residential customers are only a contact person and no company. The list displays both...