Auto-fill with relationships?

[brandon-castleton]

Hey all,



Still very new to Access. I've been watching tutorials to help me learn how to use the program and so far, so good. I have one question that was either missed somewhere or somewhere deep in the tutorial I won't be able to find just yet.

I have a table I will be using to select products with clients. When I select a product from a drop-down (relationship I made to a different table) I would like the cost of that item to appear in the row directly after it so they will know how much it will cost if they go with that product.

If someone could give me a quick crash in how to do this or where to go to watch a tutorial on how to do this, it would be extremely helpful.

Thanks in advance!

[pbaldy]

This type of thing?

BaldyWeb - Autofill