Extraction of values using the "Default Value" field

[zckzck]

Hello,
I manage an access MDB, which contains two tables.
In one of the tables (Table A), I would like to insert a "Default Value" that will be extracted from the other table (Table B), everytime I add a new row.

For instance, the value I would like to extract from Table B is "900".
When I add a new row in Table A, I would like it to use "900" as the "Default Value".
But tomorrow, for example, the value in Table B will be "910", and so when I add new rows in Table A, I would like them to be "910", but at the same time I don't want the rows that I added a day before to change (from "900" to "910").

I tried going to the "Design View" and under the "General" tab, use the "Default Value" field by using an SQL query, but that didn't work (or maybe I just did something wrong).

How can I do this?

Thank you!

 

[The_Doc_Man]

I'm not going to second-guess the requirement, but what you are talking about isn't a "default value" if it changes that often.

You need to obtain that value through some sort of joined query to do the lookup that you need.

 

[jaydwest]

How are the values in table B set?

 

[zckzck]

Doc Man - Do you have a suggestion how I could do that?

jaydwest - The values in table B are set manually.