Im having a problem with referances.
I have a form with references, and a nested form inside this form. This nested form also has references. I want the references in the Nested form to be dependent drop downs based on a reference selected in the parent form.
Machine in the maintenance table is also referanced
The User selects a machine the maintenance is being performed on,
They Can than go to the next form and select what parts where used to repair the machine.
Depending on what part was selected in the maintenance form, I only want to show the parts from this machine in the drop down/reference.
Also when they select a category, I only want them to see the parts from the selected category for the machine (Selected in the parent form)
This is my maintenance Table/Form
The is my parts used Table
Nested form(PArts used)