darren_access
Registered User.
- Local time
- Yesterday, 19:15
- Joined
- Jan 8, 2018
- Messages
- 57
I have a project worksheet (parent) that has a list of PO's in the main form based on project Id.
The sales order worksheet subform has a combobox that I want to only include PO's for the current project. I'm querying the PO table which has a project_id fk.
Where clause for the PO combobox would read "where PO.project_id = ______.project_id"
How do I reference the current project_id in the main form?
Thank you!
The sales order worksheet subform has a combobox that I want to only include PO's for the current project. I'm querying the PO table which has a project_id fk.
Where clause for the PO combobox would read "where PO.project_id = ______.project_id"
How do I reference the current project_id in the main form?
Thank you!