Lookup in a Query?

[PeterM]

I created a query from a table with 3 fields:

CartridgeID (KF)
Brand
Unit Price

I want to be able to create a query where it is possible to have a dropdown list of the CartridgeID's as the first field and then for the correct brand and UnitPrice to be displayed depending on what CartridgeID is selected.

Could anyone give me advice on how to do this? I am unsure whether i have to edit the original table or what so any help would be greatly appreciated.

Cheers!

 

[Alansidman]

Peter;
Take a look at this. I think this is what you may be looking for from your description.

http://www.fontstuff.com/access/acctut10.htm

Alan

 

[rockyjr]

Here's an example in Access 2003 and 2007.

 

[PeterM]

Thanks guys, I will try and implement that stuff tomorrow.

The sample database had sort of the feature I want, I'll tweak it tomorrow in my main database but it should work!

Thanks for the helpful replies

 

[PeterM]

Ok I have had a go and it provides the feature that I want but I'm having problems expanding it.

My Example.

I want to be able to create an invoice form so that I can choose customer details at the top section. (Already Achieved from CustomerTable).

I then want a subform with a way to input several cartridge details as if it was a real order for a customer. I need to be able to start with the Brand, then get a dropdown of all the CartridgeID's assosciated with that Brand to be available in the next Combo Box.

When a Brand and Cartridge ID have been selected, I require the price of the individual cartridge to be displayed at the end of that row.

I think then I need a macro to insert a new row and the process to start again.

Any advice on how I would achieve this?

 

[PeterM]

Anyone able to help on this? I still can't get it working

 

[neileg]

When a Brand and Cartridge ID have been selected, I require the price of the individual cartridge to be displayed at the end of that row.

Do a search in these forums for cascading combo boxes.