DT4K
Diamond Member
I added a foreign key constraint to one of my fields.
When i go to the insert screen now, the field is showing up as a drop down instead of a text box, as it should.
But the drop down has each value from the other table listed twice, once with a minus sign before the value and once with the minus sign after the value.
So the table that is being referenced is a list of names that looks something like this:
Bob
John
William
But when I go to insert into the other table, the dropdown for the name field looks like this:
- Bob
- John
- William
Bob -
John -
William -
Any idea why?
When i go to the insert screen now, the field is showing up as a drop down instead of a text box, as it should.
But the drop down has each value from the other table listed twice, once with a minus sign before the value and once with the minus sign after the value.
So the table that is being referenced is a list of names that looks something like this:
Bob
John
William
But when I go to insert into the other table, the dropdown for the name field looks like this:
- Bob
- John
- William
Bob -
John -
William -
Any idea why?
