If I use a PK table I will then have gaps in my IDs. I don't want any, is there a way to know what the next ID is or use flags on the records for inprocess and reusable and take the IDs depending on these flags or by adding a new ID?

Tyler