Noob and I’m working on my first Master/Detail form. I’ve watched the videos to get this far.
The Master form has a PK of User Id, and the Detail Form has a PK of User Id + Customer #. Forms display fine and I can view and scroll through the Master items and the Detail items. I don’t see the Delete key on the Detail Form and it doesn’t look at all like it does when I run it alone.
That’s first problem
Here’s the second problem.
On the detail form I need to be able to add/delete any customer numbers associated with the Master form. I am not using Update for the Detail Form. Users can Delete and Add instead.
To make it easier for users to add the correct customer I was also trying to get the Detail Form to pop up a list of Customer Names (rather than numbers) so that Users just select by Name and have the Customer number added to the detail database table.
I setup the Detail Form with a SELECT of Customer Name using the Customer Number. When I run the detail form alone, it works fine. I can also see the Insert and Delete buttons and select from Customer Names when run by itself.
But when I run the master/detail together I don’t get the popup and cannot add a new customer or delete the customer.
FOUND THE PROBLEM. I removed and re-added the detail form and it started working!
