File relationships

[bwill2000]

Dear All,

Is it possable to do the following, if yes how?

I am trying to build a filemaker database, to be used via the web. This database will have data inported from Sage accountting software (which is really MS Access) and then the user will use the web interface to view information on a job number. Now sage is split into many different tables and queries, I have made loads of extra queries using MS Access to simplyful some of the data.

Each MS Access query table has a job number field, what is the best way of inporting this data into one layout that the web interface can see to search for information on one job number.

I was thinking of making one FMP database for each of the access queries, inporting the data into them, then creating a parent FMP database, setting up an relationship to the child databases and somehow displaying all the required data.

Any ideas?

Thanks

BW