On Wed, 2010-09-01 at 14:20 +0800, James Elliott wrote: > I am building a bookkeeping system in BASE to replace the one I have > been using which is a series of Calc spreadsheets. > > I have my Bank details in tblBanks (Name of bank; branch number; > address; etc) > and individual account details in tblBankAccts (Bank_ID; Account name; > Account number; etc) > > In both tables I have the Primary Key ID set to 'Auto increment' and its > type is INTEGER. > > In tblBankAccts the ID field (and Primary Key) appears as <AutoField> > and cannot be edited, which is correct.. > > However, in tblBanks I /can/ type something into the Primary Key ID > field, even though it is set to Auto increment, and therefore should not > be editable. > > Why is this so? >
Hi, Why? - Don't know, in this exact instance. Until recently the ability to edit these fields was the norm in Base. (not everyone considers that wrong - many (some) db engines allow you to enter data, only when a NULL is sent on insert is the auto_increment function triggered) In both cases are you talking about the DataView (dbl click on table name)? Is one a form? Is one a query? Is one a form fed by a query? Personal advice - never show those fields - they should have no meaning to humans. In the table view, select the column, right click and HIDE - this will be persistent. Drew --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
