autosplit property

karuchuakaruchua Member Posts: 151
i have a table with the following key "type,no,line no" and i have two forms inserting records to the table based on the type.

on both forms ,i have set the autosplit property,however i cant insert records from one of the forms yet its type is different.

Comments

  • DenSterDenSter Member Posts: 8,307
    Autosplitkey problems are usually caused by the sort order on the form. You have to keep the sort order by the primary key. Another common problem is additional filters on the form. Make sure that the only filter is on the type field.
  • David_SingletonDavid_Singleton Member Posts: 5,479
    DenSter wrote:
    Make sure that the only filter is on the type field.

    Don't forget No. :wink:
    David Singleton
Sign In or Register to comment.