Next problem I have with the database is : I have a main form with a unique number for each record containing 20 fields. I have a subform on the page, which contains defects for each of these records (many defects for 1 record). This all works ok, but now I want to go down 1 more level and be able to order parts for each separate defect. Now I'm stuck... I used the same relationships structure as with my main form and subform, I refer to the unique number for each record on my subform but it wont accept it. It keeps showing #name? and returns all records I have in the underlying table.
I would like this last form to open as a pop-up when clicking a button on the main or subform.
So let's revise with an example : I have a record entered in my database. I add 2 defects for this record. No problem. Now I want, when one of the defects is added in the subform, to order parts for this defect so click on a button in the main or subform and pop-up my parts screen. I should get an empty screenm since the reference number for this part order is my unique defect number. This is where it goes wrong.
Tried a search already and found some code, but it doesn't seem to work at all...
Thanks in advance
I would like this last form to open as a pop-up when clicking a button on the main or subform.
So let's revise with an example : I have a record entered in my database. I add 2 defects for this record. No problem. Now I want, when one of the defects is added in the subform, to order parts for this defect so click on a button in the main or subform and pop-up my parts screen. I should get an empty screenm since the reference number for this part order is my unique defect number. This is where it goes wrong.
Tried a search already and found some code, but it doesn't seem to work at all...
Thanks in advance
