Q. Lets say: I have a Field called: CoID (AKA: company id) and when I create a new Table called Company want to have the following:
CoID ( But when creating this field ) WHAT statement would define it, to auto number by one and lock that number )
don't want any to change the CoID # that has been asigned.
ie: CoID: 1 Company: XYZ Address: 123 Main St City: Nowhere State:WA Zip:22309
Next Record CoID: 2 Company: ABC ...etc...etc
TKS -
Rick
