Circular References?

[CurlyD777]

Hopefully this is a simple question...

I have a main sales database full of accounts and sales. This was designed to simply keep track of sales based on who/when, etc.

Now I've added an external file that is a database that handles invoices / payments. In the main database, I reference this file as an external source, allowing me to show transactional data for each account.

In the invoice / payment database, I reference the main accounts / sales file as an external file. I need this to lookup sales details based on sales for invoice creation.

I know this isn't much different than having 2 or more unique table occurrences in the same file, but I'm not so familiar with external sources.

All of this is on a FileMaker server, and I'm concerned that I might be causing a circular reference since each file references each other.

Am I ok to do this? Any feedback is much appreciated.

[bruceR]

Not a problem. Done all the time. But - why not just try it?