Ideas on managing appointments

[Homegrownandy]

On the database I'm able to add an outlook calendar appointment though some VBA. Specifically I'm using this code:

https://support.microsoft.com/en-gb/kb/160502

And I can also create a linked table in the DB which I can delete these appointments from. What I would like is for the appointment information to be linked somehow. On the linked table there is no PK field so i have no idea how I can link this to any data I have once it’s there.

Ultimately if a job is canceled I want the user to find that job in the DB and cancel it and it is removed. So, a link to the created appointment is important.

The following picture is the details of the linked table I was wondering if its possible to add a field and link it to the ID of the table im using to import these appointmets.

Or prehaps manipulate an existing field there to do the same role. For example the subject field could be used to import the ID then the database could use this information to handle the two tables.




all thoughts appreciated.

[vicsaccess]

theoreticly it would seem possible. i haven't done this code yet but if i'm understanding it correctly i would assume that if you added a autonumber PK to the table, then upon saving the record you captured that PK and saved it as a FK in the second thus creating a possibility for a cascading delete? just a thought, maybe someone will be more familiar with this situation.

[Homegrownandy]

I'm working on another solution where by all appointments are added using the "site name", "project name", "number of visits". Which actually brings me to an entirely different problem.

Using this method will create unique "subject" names for each appointment. I can then use a query to search for names matching that in the linked table.

New thread here for that problem:

https://www.accessforums.net/showthr...583#post313583