The model contains the tables shown in the graph below. The DEVICE table has two one-to-many relationships:
DEVICE -> INSTRUMENT
DEVICE -> DEVICEPART
| | |
^ ^ ^
The DEVICE->INSTRUMENT generates DEVICE.INSTRUMENTLIST as it should. However, it is treating the DEVICE->DEVICEPART relationship backwards and is generating a DEVICE.DEVICEPARTITEM member instead of DEVICE.DEVICEPARTLIST.
I have double-checked the relationship definitions and they look correct. Also the graph generated by SQLServer is correct so it got informed of the correct relationships.
As additional info in case it helps…the DEVICEPART table used to be set as an Associative Table but I subsequently turned that off as I need to reference that actual DevicePartId to another table and associative was just
not going to work for me. I of course re-generated and re-built and re-upgraded the database after that change.
Using VS2008 NHDAL
I have forwarded the model to email@example.com so you should have it if needed. Thanks for your continued help.