I have two tables:
Games( name, current_step, #foreign key to Steps table #other fields... ) Steps( name, game_id, #foreign key to Games table #other fields... )
In other words what I want to achieve is a Steps table where each step is linked to its game and in some way I want to keep track of current step. Which is the best design to do this? Is circular foreign key acceptable?