Newbie to Access here...
So far I've avoided basic in all its forms, including the visual, but I find myself having to do some stuff with Access.
I've got a form with a master record and a sub-form displaying detail records, 1 to M relationship. I'm not displaying the linking field on the subform. When I want to add a record to the detail table table, I want to capture the key field from the master table and insert it automatically into the link field on the detail table. Any way of doing this? I appreciate the assistance.
So far I've avoided basic in all its forms, including the visual, but I find myself having to do some stuff with Access.
I've got a form with a master record and a sub-form displaying detail records, 1 to M relationship. I'm not displaying the linking field on the subform. When I want to add a record to the detail table table, I want to capture the key field from the master table and insert it automatically into the link field on the detail table. Any way of doing this? I appreciate the assistance.