I've been thinking about this for a while and messed around with a couple different ideas that worked but that I didn't like. I'm hoping some of you may have a suggestion or two on the best way to to this.
What I have is a grid that displays information about our drawings; including a button to download the drawing. This grid is based on my "drawing" table.
I have another table that's not included in the query for the grid that has a 1 to many relationship with the drawing table. This is my "product to drawing" table.
The product to drawing table is used in other parts of my application to link a product to a particular drawing.
I don't want to include my "product to drawing" table on my grid as it would result in duplicate records due to join conditions.
I have a button (on each row) that opens up another grid based on my "product to drawing" table and linked to the drawing number.
What I WANT is for the button to change it's style or image so that the user knows when a drawing is not matched to a record in the "product to drawing" table without having to click on the button. Then they can click that button and correct the problem.
Is there an easy way to do this that I'm missing?
It would be easy to do this backwards from the "product to drawing" table but most users spend their time in the drawing area and I think I have a better chance of them correcting the records from there.
Any suggests would be helpful.
Thanks!
Jinx
What I have is a grid that displays information about our drawings; including a button to download the drawing. This grid is based on my "drawing" table.
I have another table that's not included in the query for the grid that has a 1 to many relationship with the drawing table. This is my "product to drawing" table.
The product to drawing table is used in other parts of my application to link a product to a particular drawing.
I don't want to include my "product to drawing" table on my grid as it would result in duplicate records due to join conditions.
I have a button (on each row) that opens up another grid based on my "product to drawing" table and linked to the drawing number.
What I WANT is for the button to change it's style or image so that the user knows when a drawing is not matched to a record in the "product to drawing" table without having to click on the button. Then they can click that button and correct the problem.
Is there an easy way to do this that I'm missing?
It would be easy to do this backwards from the "product to drawing" table but most users spend their time in the drawing area and I think I have a better chance of them correcting the records from there.
Any suggests would be helpful.
Thanks!
Jinx
Comment