Dear All:
Here’s a bit of a stumper that should not be too hard but it is.
I have a field that I would like to append via a query to a table and have the values be “SHPF”(prefix)and 1 greater than the last value in the table. The field in thetable that needs to be “incremented” is called ShipmentInformationID. There would be at least one dummy record in the table so that values could be incremeneted from it, i.e. “SHPF1”.
So, via an append query, I want to append a generated Primary Key value (SHPF2, SHPF3, SHPF4, and so on) with every record that I append to the table (thus autogenerating a Primary Key without using the lame AutoNumber feature)–I need these Primary Keys to be usable later in queries, and AutoNumbers just fall flat when you try to use them for that sort of thing.
I have tried this by assigning the value of the Primary Key field to a function that finds the maximum value of the ShippingInformationID, but all it does is put the same value on all rowsin the query!
Is there a better way to do this?
I need to use Access 97 (so pleez don’t tell me to go buy SQL Server or something!) More than willing to try DAO or some other method, so any Access 97-capable solutions are welcome.
Thanks in advance.
