I use lookup table with Parent/Filter. I use grid add.
Filtering is working for the 1st grid, but then not working for 2nd grid and also cause 1st grid not working (Result blank)
Please help What codes I supposed to add? or any other tricks? Thank
I use lookup table with Parent/Filter. I use grid add.
Filtering is working for the 1st grid, but then not working for 2nd grid and also cause 1st grid not working (Result blank)
Please help What codes I supposed to add? or any other tricks? Thank
mobhar wrote:
Is this a Master/Multiple-Detail relationship?
Yes mobhar. This is sales + sales detail.
I have a sales_detail table which selling an item and the item has different prices. Once user has chosen an item, he can choose the prices (from another table) of the particular item. This dynamic selection is working fine for the first grid (prices list appears only of item selected), but not for the second grid (prices list blank)
ameisfine wrote:
This is sales + sales detail.
Are you sure this is a "Master/Multiple-Detail" and not "Master/Detail" relationship?
The main reason why I asked you a question about "Master/Multiple-Detail", because you mentioned "first grid" and "second grid" which means there are at least two detail tables so that there are two grids.
mobhar wrote:
ameisfine wrote:
This is sales + sales detail.
Are you sure this is a "Master/Multiple-Detail" and not
"Master/Detail" relationship?
The main reason why I asked you a question about "Master/Multiple-Detail",
because you mentioned "first grid" and "second grid" which means
there are at least two detail tables so that there are two grids.
Ups, sorry my bad explanation. This is Master/Detail NOT Master/Multiple-Detail.
First grid means the first row of grid add data. When I add grid data in first row is working fine, but 2nd, 3rd, .. is not working fine
kirondedshem wrote:
= Yes for sure they have prices, I tried different order of item and always good in the first row
= I tried fill the second row first, and result is blank. Seem this selection is only working in first row
= Already. I use view table for the lookup. Force selection checked. All working fine is the first row.
= not check yet. But when I use add page (not grid add), the selection is always working fine
= I tried fill the second row first, and result is blank. Seem this selection is only working in first row
I feel this is the real hint to the problem but i still cant understand why, lets take a short in the dark although you might have done this you can retry just to be sure.
SOLVED.
in Parent/Filter #1, I let Parent table blank and just fill Parent field and Filter field and everything is fine. All rows is able to be filled while prices filtering is working normal as well.
Before I fill completely, Parent table is filled with sales_detail, and it caused the problem
I dont really understand but it solved the problem :)
Thank you.