[RESOLVED] Adding New Records Help

Hi guys, I just need a quick help here. I know this already but I forgot how it is done.

I need to add a new record on the table and at the same time I need to get the unique id of the newly added record. How do I do that? Im sorry for asking this, I just need this right away.

Thanks in advanced.

Note: I can't use the max() or top 1 something because there may be 2 persons trying to add a new record

What type of database are you using?

At the top of this forum is a sticky thread called FAQs/Tutorials, and you will probably find the answer in one of the first items: How can I get the auto-generated AutoNumber/Identity value for the record just added?

Thanks. sorry for not searching. I just dont know what terms to search