I have 2 tables - tbl_ultrasound and tbl_officevisit
tbl_officevisit primary key field (ov_id) has auto numbering
tbl_ultrasound has ov_id within it as a foreign key
When a auto number is added to tbl_officevisit because a record has been added, I would like tbl_ultrasound foreign key (ov_id) to populated automatically
How do I do this? Do I create an append query? Can someone please explain this to me.