Synthetic keys and circular references at relations
I have a problem creating my data structure. The problem is that I have to display relationships between different documents with different unique IDs, but at the same time I have to offer the possibility to select them by date.
(It should be possible to see all children of several fathers and to restrict them by date.)
In my attempts I had either synthetic keys or circular references.
Is there a way to avoid them? In the attachment I have an simplified example.
Re: Synthetic keys and circular references at relations
thanks for your reply.
Unfortunately, I can't simplify the whole thing to one key.
If, for example, I have an inquiry from which five offers arise and each offer again has two orders, can I no longer comprehend that? In addition, it becomes even more complicated if I only want to see some offers of the five in a certain period.
If this is possible with your suggestion, can you please create an example for me?