Hi Jay and Michal,
I was on vacations and couldn’t respond earlier.
First of all, I’d like to thank you Michal for your opinions and suggestions.
To the matter: I read the communication carefully and I think that TDM now works OK. Michal’s feedback about PKs and relationships is correct.
Also, I think it is not a good idea to display solid line for relationships that cannot be identifying. This may result if confusion.
Jay, let’s focus on what can be modeled and how to better automate the required actions. I can write set of macros that will, for example:
- add new entity with new PK attribute automatically (no need to add PK attribute manually)
- open a new form where you will be able to select parent table, child table and specify name for third table. The macro could create the third entity, and new unique/alternate key to it and link PK attributes to the unique/alternate key. etc.
Some actions can be nicely automated. Please read this article:
What I need is to perfectly understand what you do. If you can, send me reverse engineered model to firstname.lastname@example.org and provide additional information about steps you are required to do to get what you want. Ideally based on some real model and not only sample.
Again, thanks for you feedback and suggestions.
Message was edited by: vaclav