Hi,
ER/D2W will pick an attribute for a related entity. Often, I find, it picks an attribute I don't want. : < ( Is there any good general way to choose which attribute gets thrown up in edit/inspect tasks?
For example, let's say we have a person table, related to many events, which in turn are related to many event-details. This is a fairly common pattern.
person< >> events< >> details
Q1. If, every time D2W must pick a related attribute from the person table, how can I make sure it is the one I want to use? i.e., override the default? What is the best general way?
Q2. If I am editing an event-detail, how can I use for a query a numeric attribute from the person table in a keypath? D2W seems to only accept strings. I could be doing it wrong, but if I use something like "person.personNumber" in the key keyWhenRelationship, D2W gives me an error:
java.lang.NumberFormatException: For input string: "1%"
Also, when I turn on 'rule tracing': Just where do I seen the rules being traced?
Thanks,
gb |