Get date from another table

[Crabman1985]

I need to record cube result for each concrete element that has been produced.
I have a table with the batch number of concrete used and then 7 day results and 28 day results.

I have completed the full list of batch numbers for all batches.
How do I input the batch number only and results are automatically pulled into my main table called elements

 

[DHookom]

Can you provide more information about your tables and relationships? Are you wanting to open a filtered form or report? Have you created the form/report?

 

[GPGeorge]

You do not need to "pull" results from one table to another table in a relational database application.

As Duane suggested, we need to see the tables and the relationships between them to offer more concrete help. However, it is highly likely you can handle this without duplicating data.

 

[cheekybuddha]

... to offer more concrete help.

I see what you did there!

 

[GPGeorge]

I see what you did there!

Sometimes the jokes write themselves.