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
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