Adding records through a portal
I have a table (Table1) with a portal for a related table (Table2). Table2 has a primary key with the option auto-entry set for a serial number and validation set for unique value. Using this primary key I have linked to Table1 to a foreign key. I have set the relationship so records can be added to Table2. I can add one record from this portal. However, if I try to create another record I receive an mesage box tha says "The primary key is defined to contain unique values only. You must enter a unique value." Since I set key to auto-enter a serial number I expect it would have happened. What am I doing wrong?