How to fill one field with data from many different fields
I´m doing an invoicing database, but I need to be able to get the PART_No. field from different databases. I have different DB for different products and I need to be able to get the values from all products into just one.
The problem is that I have many products in different DB´s because they are very different things but I wanted to know if it possible to get the data from this one field (P/N) so I can make only one DB of all products.