Gossamer Forum
Home : Products : DBMan : Customization :

Pulling info from 2 databases

Quote Reply
Pulling info from 2 databases
Can anyone help !

I'm running 2 databases:

orders - Order Information
orddetails - Order Details (Products Sold)

Question - How can I show the order information with the relevant order details on the same page at same time i.e. like an invoice

So I can search say the orders database and show the full order details for that order on one page as at present they are on two seperate pages...
Quote Reply
Re: [RobR] Pulling info from 2 databases In reply to
Sounds like the relational mod to me.

Something I noticed after using this mod a few times is that you need not do EVERYTHING that the mod can do. You can just pull in information from the second database based on some item in the record.

here is a link.
http://www.jpdeni.com/.../Mods/relational.txt
Quote Reply
Re: [RobR] Pulling info from 2 databases In reply to
It's possible to do what you want... you have to "switch" databases back and forth to get the information you are looking for. I've got the code and can give you a sample... see attached at the bottom.

Here's the link to the whole thread for reference:

http://www.gossamer-threads.com/perl/gforum/gforum.cgi?post=162559
Quote Reply
Re: [Watts] Pulling info from 2 databases In reply to
Thanks for the help

I'll have a good look through and test the mods

Thanks