Data model advice asked for

[Scott_Sauyet]

@Bob_Jansen

The FM database has a pretty normal data model, tables for each of the entities with mapping tables to implement many-to-many links between records in the tables (eg. many artworks can link to many consignments, etc).

Now, TW can implement such relationships a number of ways and I am seeking advice and guidance from the experts on this forum before I commit to one way or another.

I’m definitely not an expert, but I do have thoughts about this, which I’ve been discussing in another thread, and also discussed quite a bit in an earlier thread and partially implemented in a demo wiki.