One Back End and Two Front Ends or two custom Menu's ? (Split Database)

[Dave Elliott]

I have a DB that is split. I use the one (Part of DB) for Invoicing and the
other for Payroll, that is, they are both in the Front End.
Unsure of how to approach this.
Goal is to be able to use both Invoicing and Payroll, but with permissions
for Payroll Module. Have this in place already.
Sometimes the one module Invoicing needs to acces the payroll module and
vice versa.
Example the Invoice Modules need to lookup a TimeCard with matching ID in
the other Payroll Module.
Or on the Invoice form in the Invoice Module it allows you to create a
TimeCard from the Invoice with matching Order ID., which is in the Payroll
Module. What is the best way to approach this ?



Do I A: Use a Custom menu to accomplish accessing the Payroll Module,
Invoice Module is accessible to everyone via the normal Menu.
B: Create another DB with the Payroll Module in it and link back
to split tables, i.e. Back End ?
Payroll Module is password protected while the Invoice module is not.


Thanks,


Dave