I've got tables with parent child relationships
Organization
Project
Milestone
Action
I've got a form Actions that lists mostly Action detail, with some Project & Milestone identifier info
ProjectTitle MilestoneTitle ActionTitle OtherAction Detail
where ProjectTitle and MilestoneTitle are provided from a query that does joins to get those
fields from the associated Project and Milestone tables.
I want to add to Action table through this form. So I need to tell it which Milestone record.
So I have a ComboBox with ProjectID that allows me to lookup and change the ProjectID on the form, and then OnChange to use DLookup to change the ProjectTitle field. Same for MilestoneID/MilestoneTitle
with MilestoneID constrained to children of that ProjectID.
The problem is that when I try to use this scheme to add an Action record, it says "can't do it, no organization record". So it's acting like it wants to add a Project record.
I suspect this must be because the form record source has the joins to the Project record, and the combo box field for ProjectID has ControlSource from that query. Or something.
I want to be able to fill ProjectTitle and MilestoneTitle properly for existing Action records.
I also want to be able to select ProjectID and MilestoneID (and display corresponding Titles) for add Action records, using the "combo box ID lookup" + "on change Title Dlookup" mechanism above. I've done this in other apps, but it was too long ago...
==> OR do I have to build a little "add record" form in the footer, get the projectId, milestoneid there, add the Action record, get the last record, use it as a bookmark, then go fill in the new record?
Any help with this would be appreciated.
Thanks!
Start Free Trial
