Query to fill up table for the day

[saudkazia]

hi.

Suppose I have two tables Batch, Farm

Basically I want to create an append query so that for the day selected in a form tied to the farm table, I would be able to create multiple records based on the number of records in the batch table with no duplicates.

for instance. batch table has 1,2,3,4,5,6,7 for example

farm table should be appended with
date, 1, other fields
date, 2, other fields
date, 3, other fields
date, 4, other fields
date, 5, other fields
date, 6, other fields
date, 7, other fields

where date is the date selected.


I know this is vague but if someone can point me in the right direction it would be good.

 

[sneuberg]

If you just want to append the records from batch to farm with the date from the form then create an append query in the query designer and to add the date put in an expression that's a reference to the form textbox with the date. I suggest using the expression builder

You should end up with something like:

Expr1: Forms!TheNameOfTheForm!TheNameOfTheTextbox