Auto-population of field

[ttuguy]

Hello all,

I have another newb question

I have a sheet of inventory I am working on creating. The price for storage for an item is determined by 2 things. 1. the type of material and 2. the size of that material. I have created a table with the material types and sizes. Is there a way that I can have the price automatically populate when I select the type of material and then size?

 

[plog]

Since you've posted this in the tables section, I believe you want the price to automatically populate into a table. This is not the way it should be done.

Instead, you should use either a query to join your price table to your other table. Or use a Dlookup (http://www.techonthenet.com/access/functions/domain/dlookup.php) if you want to lookup the price of an item for a form/report.

 

[ttuguy]

Thanks for your reply, so just I am clear, there is no way to prepopulate a table?

 

[plog]

I'm sure there's a way, its not the correct thing to do.