Hi
I have been asked to create a database for a user to store two kinds of quotes repair and production quotes, these had to be kept seperate so I have split it between a main repairs table with other repairs tables connected to it and a production side with the same. In each main table is a quote number (not a primary key) its used just for the uses refence so they know what quote number to put on documentation etc, but this number has to increment for both the production and repair sides e.g. if you created a production quote with the number 8798 then went the the repair side it would show 8799.
I have tried creating a Dmax counter with a +1 that looks for the largest number of both sides but have been unable to get it to work.
what kind of expression should i put on a form to get the counter working?
Is this even the right way to do this, is there a better way?
Thanks