How to determine key in unbound form?

[davidd31415]

I am using unbound forms to create a "help ticket" type of system. I would like to display the Ticket ID (key in the table) on the form as it is being entered.

My problem is since I have an unbound field the key hasn't been created yet.

I thought about creating a special blank record (all zeros for fields perhaps), getting the key, and then updating that record instead of inserting a new one. I would like to allow for multi-user functionality in the future though and I could see this being a problem in that case.

Does anyone have a solution for this problem?

Thanks,

David

 

[TheAceMan1]

How are ya davidd31415 . . .

Have a look at the aggregate function [blue]DMax[/blue].

See Ya! . . . . . .

Be sure to see FAQ219-2884: