Basically I have one database (a) that deals with Part Nos and (b) another that would need access to some of the data/info stored in (a).
How can I get access to the info from (a) eg Part No & Description shown in (b) as a Drop down list. Taking into account that (a) could easily have over 2000 records that do change. Once chosen in (b) they would remain on that record, so not worried if that record gets deleted from original (a). Information would always be onsided ie I would never change (a) records through this link.
All the info I've been able to find so far keeps talking about importing records into a new table, but I don't see how that would work for me needing the latest info from (a) streamed into my (b) database. Both databases are sitting in the same FM12 Server.
Thanks for any help you can provide me.