PDA

View Full Version : Mulitple stock refrences?


Ali B
10-Apr-2003, 02:30 PM
Is there possibility to check multiple stock refrences?

So that in your database you can have 1 product, but 3 different stock amounts because I will be updating my stock list from 3 different suppliers, so I want to be able to use all 3 databases and stock amounts.

cdicken
11-Apr-2003, 01:21 PM
This is not possible in the software I'm afraid.

The only thing you could do (if you were familiar with Access) is to have a table in Microsoft Access which held the three stock values, and then use a 'Make Table' query to produce a table with all the stock values added together into one stock value. You can then link to this new table by using Actinic Business/Developer's external linking feature.