How to set multiple objects as the sources of crossover fields
Here is an example showing how to achieve this:
Eg. You want to create a crossover so that:
In the Work Order Tracking application/ Plans tab/ Materials subtab, when you enter an Item number, you can copy the LOCATION column value from the ASSET table into the WPMATERIAL.WPM6 column if the entered item is a rotating item.
If the entered item is not a rotating item, then put the ORDERUNIT column value from the INVBALANCES table into WPMATERIAL WPM6 column.
In the Crossover Fields table, enter two rows as follows:
This line means that the data from INVBALANCES.LOCATION is copied into WPM6 when an item is not rotating.
INVBALANCES is the relationship name between ITEM(parent) object and INVBALANCES(child) object.
This line means that the data from ASSET.LOCATION is copied into WPM6 when an item is rotating.
ASSET is the relationship name between ITEM (parent) object and ASSET(child) object.
3. Go to the Database Configuration application and find the WPMATERIAL object.
In the Attributes Tab then find the ITEMNUM attribute.
Enter the crossover Domain created in Step 1 into the Domain field.
Turn Admin Mode on and apply configuration changes.
Turn Admin Mode off.
Try to put a not-rotating Item value into the Plans tab /Material subtab.
Location PKG is grabbed from INVBALANCES whose Itemnum is 560-00.
NB: This is just an example. It is not a suggested requirement because of cardinality problems ie. The cardinality between ITEM and ASSET or INVBALANCES is 1:N but it should be 1:1.