PDA

View Full Version : Cascading Edit


ABC123

Sarah Mengesha
12-14-2004, 09:54 AM
Hi Everybody,

I have a web app with grids on several pages. Many of these grids have fields in common. For example, Grids A and B are set up as follows:

Grid A
Table A
customer_id
customer_phone
.
.
.
customer_name

Grid B
Table B
customer_id
email
city
.
.
.
customer_phone

As you can see both of these grids are based on different tables but with multiple fields in common. Here is the thing: When a user changes the value of customer_phone in Table A for a certain customer_id, then I want to somehow make this change in Table B for the same customer_id.

The catch: There will be multiple customer_phone values for the same customer_id in Table B, but only one customer_phone value for each customer_id in Table A. The idea is when a change is made to Table A, we have to go through Table B searching for the old TableA.customer_phone value where TableA.customer_id = TableB.customer_id.

Sorry if this is not as concise as possible.

Any ideas on how to make this happen?

Thanks,

Sarah

Selwyn Rabins
12-14-2004, 06:58 PM
isn't it possible to have a structure where the fields in 'tableA' are broken into two tables. 'tableA1' and 'commonFields'.

then fields in 'tableB' would also be broken into two taables 'tableB1' and 'commonFields'.

then grid1 would be based on 'tableA' and 'commonFields' and grid2 would be based on 'tableB' and 'commonFields' and then, if you made a change to a field in 'commonFields' from grid1, the change would AUTOMATICALLY be reflected in 'grid2' with no futher work on your part.