Feb 27, 2010 11:12 AM|klca|LINK
Hi Mr. Naughton,
Using the overriding ToString in the orange entity (t66tbl_marcasxlineas) helped a lot. (Down below the ERD is a display of the screen with sample data). By the way, "MARCAS" means "BRANDS" in English.
Which is ok if you were not to have in count that brands (t25) depends on
localtype (m14) too, then I think, it should be necessary to carry on the key value of the localtype (m14) as to display properly the values that could be matched in the
intersection table (t66) as to avoid creating the Cartesian Product of the two tables
(t30) and (t25), because not all "brands" could be matched to a "line" because, as is shown below,
(t25) depends on (m14)
For instance, as an example, "Coca Cola" shouldn't be associated ever to a kind of store "Farmacia" (which is a drugstore
and I undesrstand that it could be possible to sell coca's at a drugstore, but let just assume that in this drugstore it shouldn't happen) because coca should belong to the localtype "Tienda" only (which is a kind of supermarket) .
How can it be customized?. I mean, how can the value could be carried out, like PostBack function for each one of the DropDownLists that could change seeing always that the combination is worth in relation to the (m14) table?
Carlos Porras (El Salvador)