Hello all,
We have one database with table Incidents and table Task, every task must be assigned an incident to it (one-many).
We will also have another database with table task. Those are singular records, not related to anything, just task and due date, completion date.
Yesterday, my boss asked if we can see outstanding tasks form first database in the second one, but we don't want to see tasks from second database in first one.
Here is the question:
Do I just link table from first database to second one, I will see all records and they will update no matter which front end we use?
Or do I rather have to create a separate table in second database and just pull records to it from first one.
How would it work if record is updated in either, how would they sync?
Can you please verify if my thinking is correct or point me in the right direction?
Thank you
We have one database with table Incidents and table Task, every task must be assigned an incident to it (one-many).
We will also have another database with table task. Those are singular records, not related to anything, just task and due date, completion date.
Yesterday, my boss asked if we can see outstanding tasks form first database in the second one, but we don't want to see tasks from second database in first one.
Here is the question:
Do I just link table from first database to second one, I will see all records and they will update no matter which front end we use?
Or do I rather have to create a separate table in second database and just pull records to it from first one.
How would it work if record is updated in either, how would they sync?
Can you please verify if my thinking is correct or point me in the right direction?
Thank you