Simple problems

[site]

Hi,

How to automatic show up AUTO_ID(text box) in the add new form? Example: When I click "AddNew" buttom, the AUTO_ID(auto number) should be showed in this form.

Any help?

Thank you very much for your kind help.
Jing

 

[Databaseguy]

On the table that the form is bound to, set the ID column (field) data type to AutoNumber

 

[THoey]

DBG, I think the problem with that is that the autonumber isn't assigned until the record is saved. I "site" will have to save the record before they can see the ID. This would require a little bit of work to delete same in case user decided to cancel. Terry M. Hoey

 

[Databaseguy]

Actually, it's assigned when you enter any value into any of the fields in the same row. That's why when you cancel out it'll skip a record (sequence)
Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy