originally had 1 big table with 190 records. i had to split it to 2 tables with a relationship set on a specific field. i modified my form to combine the contents of both tables via my relationship. as i went back and added 10 more records, these...
originally had 1 big table with 190 records. i had to split it to 2 tables with a relationship set on a specific field. i modified my form to combine the contents of both tables via my relationship. as i went back and added 10 more records, these records can be found/seen directly on my first (original) table but they were not inserted in the second table.
on my form, i can only see up to the original 190 records, and NOT the last ten records added after the table split.
is there something that i need to do to my form to go beyond 190 records?