Adding a ID number to records

[Travis]

I need to know how to give my records in multiple tables unique ID numbers. How should I do this?

[jscooper]

Assuming you have a serial # (SerialID) in each table already:

In each table. make a global and/or calculation field, call it TableID and set it = "TableA" (or whatever you want to use to identify the table), then make a field called "GloballyUniqueID" and set it equal to

TableA & numtotext(SerialID)

If you want it to be numeric, then set a very big number for TableID, like 10000000 and set GloballyUniqueID = TableID + SerialID (then set TableID to 20000000 in your other table, 30000000 in the third, etc).

Jeff

[Damocles]

There was a great (revisited and lengthy) discussion of unique IDs in the "Sample Files" forum. IF you want each record to have a unique ID, the solution presented is very well done.

The subject line for the discussion is: "Unique Auto-entered Primary Key IDs v2.0"

Good luck!

Paul