Ive created a form with a subform, as i have a one to many situation, IE...customers who have several leaflets delivered to each of them. i complete the data for one customer and then put in several leaflets against that one customer.
However when it goes back to the table its only completing one row with the customer on and the following rows only have the leaflets on.....is this a relationship problem ?
Example of what is happening in the table;-
This is how the table should look;-
ID Venues Town Area Attraction Leaflet No Delivered Date Delivered Month Delivered Driver 7 Admiral house Alby 1 Colchester Zoo Summer 50 08/01/2022 January Amanda Whiting 9 Admiral house Alby 1 Amazona Zoo 25 08/01/2022 January
10 Admiral house Alby 1 Bewilderwood 50 08/01/2022 January Amanda Whiting
This is how it is looking
As you can see...the main form information is recording ion a separate line to the subform information
Venues Town Area Attraction Leaflet No Delivered Date Delivered Month Delivered Driver Admiral house Alby 1
Colchester Zoo Summer 50 08/01/2022 January Amanda Whiting
Amazona Zoo 25 08/01/2022 January Amanda Whiting
Bewilderwood 50 08/01/2022 January Amanda Whiting
regards
Robert