The fossil record is the record left in fossils. You are confusing that with the geologic column, which contains the fossils. There are 25 places in the world where the geologic column is essentially complete.The "fossil record" is an imaginary ladder of sedimentary rock layers which is not found completely anywhere on the world.
That's geology in action. Uplift, overturn of layers, erosion of softer layers, it's happening around you and below your feet at the moment, if you live anywhere remotely geologically active, but it does take hundreds of thousands to millions of years for any significant change.In many places whole layers are missing, or are out of order. You can find "young" layers resting on bedrock with supposed billions of years missing.
In North Dakota you can drill back from the Tertiary to the Precambrian.The "record" does not exist. There is no "geologic column," as you may have seen it in dinosaur books, going from Cambrian, Ordivician, Silurian, Devonian, Carboniferous, Permian, Triassic, Jurassic, Cretaceous, Palaeocene, Eocene, Oligocene, Miocene, Pliocene, etc.
But unfortunately, there is sorting of different fossils into different layers, and the sorting cannot be claimed to be based on the hydrological properties of the fossils. And of course the layers date very differently.The idea that such a sequence is actual comes from inferring that layers in one place must fit in somewhere with layers in another place, either side by side, on top, or on bottom. But who says they have to? The inference is not from science but from necessity because it comes from a naturalistic worldview where the layers must represent long ages of sequential time periods. If they are simply sediment deposits from a worldwide flood, there is no reason to assume that global sediments must have been deposited in the same sequence at all locations on the globe. So the missing layers and out of order layers are no problem in a Biblical framework.
These are ancient creationist canards, long disproved. There is no debate. There really never was.
Stuart