I have created 2 tables HORSE and VENDOR and a relationship table VENDOR_HORSE
With the foreign key in Horse being the Primary key in VENDOR (VendorID)
and the foreign key in VENDOR being the primary key in HORSE (HorseID).
It is a many to many relationship and ArcGIS automatically creates the link table -.
- yet I had to create the Relationship table which is simple and has extra fields (besides the horseID and vendorID) as Notes (text), Service (coded domain),
and Date (most important to solve many to many matter and have a relational database.
I cannot add data to the VENDOR_HORSE table.
I click on start an edit session, just as I do to add rows to the HORSE and VENDOR tables, with no problems, yet I cannot add rows to the Relationship table.
ESRI help gave instructions for adding rows yet they do not work.
- I selected a row in HORSE,
- I selected a row in VENDOR,
- then double clicked on OBJECTID to have the table fields appear in the Attribute window and NOTHING. What am I missing? Help! Thanks Bette