Importing Values from remote databases

[Jarvis]

I have a database for my cabinetshop that includes a field for measuring the square footage of materials.

I would like to multiply this squarefoot result X the current price of different types of material.

This needs to be set up as a lookup type relationship so that changes in current material price do not affect previous job cost reports.

I would like, if possible, to manage the vendor side of the business in it's own database rather than as a table within the client information database.

[color:red]Is there a way to import or lookup current prices from one database and use them in another database?

Thanks for any guidance here.

Edited October 18, 2009 by Guest

[Vaughan]

Is there a way to import or lookup current prices from one database and use them in another database?

Yes. Create a file reference to the other file. Put a table occurrence of it into the relationship graph. Treat it just like it's a local table.

[Jarvis]

Thanks Vaughan,

I'll poke around a little with that.

I'm hoping I can produce some kind of report that can access the various vendor prices and report back with recommendations weighted by price & service.