Basically I've got two databases :-
A private one which stores customer details and one which stores product info.

Now to add a product to the product database you first have to register and fill out a form with your details which get stored in the customer details database.

Both databases use the same password file.

When you then add a product you just enter the product details and thats all (all your other details are stored already), easy enough.

The problem occurs, when someone else comes along to view the product details, then I want to extract some (but not all) of the fields from the customer details database (say like company name, contact details etc), according to the user who added it, and present these fields alongside those brought out from the product database.

A long winded explanation I know, but can I do it?

Many thanks,

Mark

Are you using the relational mod? If so, the instructions should provide the answers as to how to setup your database so that you can view records from both.

You might also want to check the FAQ noted below and look under "Multi & Relational".

Hope this helps

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

 
Cheers LoisC,
Just what I was looking for!

Many thanks.