Greetings, i have two database's, one for production tracking and one for maintenance request and tracking. I have been requested to add a maintenance request form to my production database so that the operators can enter maintenance request for their equipment. This would require one table from the maintenance database being linked to the operators production database FE but i already have some issues with my old network so I'm leery of this having never done it. Will a FE see any difference in performance being linked to two BE's rather than one? My thought if it was possible would be to continue being linked to one BE for production and use an unbound entry form for the maintenance request that upon submitting the request would link to the second database, save the record and then close the link. I know i can do the first two parts, linking and saving but closing the link so that it does not continue to affect performance I'm not familiar with.
Any thoughts, ideals, direction and examples would be appreciated. Thanks