Issues in Records after append

[Anil Bagga]

I created a form and tested it by creating new data. It was working fine. See TestDB enclosed

When i appended the data from Excel one field does not capture the data from the table, all others do. I tried to delete and recreate the field in the form. No result. The field name is DebtorCode

Also the new records are created with a very different ID which is 5 digits. I experience this in my other forms also from where I have copied these tables and Form

Look forward to some helpTest18May.zip

[ranman256]

you didn't provide the excel record to paste.

[Anil Bagga]

File enclosed. Thanks Raman for the response

[ranman256]

Shouldn't debtorCode have its own table,so users can pick from?

[Anil Bagga]

Mr Raman. Each customer can be either a debtor and/or a consigne and / or an end customer for specific orders. Hence the concept to create a database of addresses with flags in one table and relationships in the other.

Wonder why only the debtor code is not copied but all the others are, when we import from Excel

[Gicu]

You just need to change the bound column of the DebtorCode combo from 4 to 1.

Cheers,

[ssanfu]

Hmmmmm........

Why does the combo box "EndCustCode" have a column count of 14 when the row source query only has 5 columns???

[Anil Bagga]

Thats it. Thanks. That did the trick

Any clue why new records suddenly begin with a new series. Fo example last record is 192 and new record added is 30431 - 5 digits. I did the following to reset the number series
Removed relationships of the table
delinked primary key on the ID (autonumber)
deleted the field
added a new field ID
reallocated primary key to ID

[Gicu]

That is a well known issue with autonumbers, they are known to skip and leave gaps from time to time, but, if used properly, it shouldn't affect their usage (to ensure uniqueness for primary keys). To reset them usually you need to remove all the records following the gap, run a Compact and Repair and re-add the records, the sequencing should start from the previous highest number.

Cheers,