Need help understanding SeedCodeComplete table structure
Posted: Thu Oct 25, 2007 7:48 am
I am customizing SeedCodeComplete for one of my clients using FM9. This is my first FM 9 work after a lot of work in 6 and 8. I am puzzled about at least two things related to the tables.
1. There are tables that don't show up in the File - Manage - Database - Tables list. One example is ContactActivity. I can see it in the Relationships diagram and via Layout Setup - Show Records From: but not in Manage ...
2. I imported data into the ContactActivity from the client's previous Contact Manager (Act!) and it appears to be showing up in the Appointments table. I don't how this is possible since Appointments doesn't seem to be joined to any thing except ApptType.
I suspect there is some aliasing or SQL View -like behavior going on, but I don't understand FM 9, or perhaps FM in general, to understand.
Please help!
Thanks a lot,
Doug MacGregor
1. There are tables that don't show up in the File - Manage - Database - Tables list. One example is ContactActivity. I can see it in the Relationships diagram and via Layout Setup - Show Records From: but not in Manage ...
2. I imported data into the ContactActivity from the client's previous Contact Manager (Act!) and it appears to be showing up in the Appointments table. I don't how this is possible since Appointments doesn't seem to be joined to any thing except ApptType.
I suspect there is some aliasing or SQL View -like behavior going on, but I don't understand FM 9, or perhaps FM in general, to understand.
Please help!
Thanks a lot,
Doug MacGregor