I tend to develop the data model in in QVWs and then use a binary to load them into the app people use. This includes the master calendar. I have one app that uses check dates. The master calendar is the latest script from the Q Cookbook (Rob Wunderlich) which takes the max and min dates and populates between. This works fine in the initial QVW. I get all dates, whether checks were written or not, like holidays and weekends. When I load this with a binary into the final app, my master calendar is missing any rows that do not have checks. From an optimization standpoint, this could be good. However, it is messing up some NPrinting reporting. Anybody know anything about this? Other than moving the master calendar script to the final app, can I do anything to stop this? And at this point I am just really curious about this behavior.
A synthetic key is not related to the data type of the field on which the tables are linked. It's auto-created when tables have more than 1 field name in common, and starts with $Syn. Chances are you would know if you had it 🙂