create record with a query in the same table

  • Thread starter Thread starter Beans
  • Start date Start date
B

Beans

Is it possible to create a record for a table with a query? I have a table
that has a moisture status (dry (1) and wet (2)) and color fields. The color
is ALWAYS the same for dry and moist. If I manually populate the dry color
and its associated color, can I query and make a new record for moisture
status 2 and populate the color with the color from moisture status 1? Thanks

Moist_Status Color
1 10 ----------manually populate
2 10 ----------query to populate
 
Back
Top