This question is locked. New answers and comments are not allowed.
I have 2 grids; grid 1(readonly) is selectable and grid 2 will load depending on a selected row in grid 1
My problem is when i try to insert new record on grid 2 i cant pass the primary key from grid 1
here's my table
Grid 1 - Orders table
OrderID(PK) Name
1 John
2 Jane
3 Johnny
Grid 2 - received items table
ID OrderID(FK) ItemName
1 1 banana
2 2 Apple
3 2 orange
4 3 iPhone
5 1 iPad 2
example:
If I were to add a new record,
a. I selected Jane
b. I want the OrderID 2 to be the default/fixed value when adding a new row
Basically i just want to get the primary id on grid 1 and be able to pass it on grid 2 when creating a new record. I don't know if i have explained this clearly enough, you may also check the attached file.
Creating this as a Master-Detail is not an option. Grid1 already implemented the master detail and i want the second grid to be separated from the first grid.
Thanks
Samantha
My problem is when i try to insert new record on grid 2 i cant pass the primary key from grid 1
here's my table
Grid 1 - Orders table
OrderID(PK) Name
1 John
2 Jane
3 Johnny
Grid 2 - received items table
ID OrderID(FK) ItemName
1 1 banana
2 2 Apple
3 2 orange
4 3 iPhone
5 1 iPad 2
example:
If I were to add a new record,
a. I selected Jane
b. I want the OrderID 2 to be the default/fixed value when adding a new row
Basically i just want to get the primary id on grid 1 and be able to pass it on grid 2 when creating a new record. I don't know if i have explained this clearly enough, you may also check the attached file.
Creating this as a Master-Detail is not an option. Grid1 already implemented the master detail and i want the second grid to be separated from the first grid.
Thanks
Samantha