well i have 2 databases
1 called action requests that has the 4 companies in it
2 the other database is used for sales , purchasing, manufacturing etc
at this time on the second database we have products which have a bill of materials attached to them which if that product is sold it generates works orders etc . but if we need to do some internal work ( testing of products etc) we still have to create products even if no bill of materials is needed. so i dont want this database for doing this type of work. therefore i was thinking how i could do it in database one as i think it is more of an action request , but i want to get reports from database 2 as these reports are more relevent to that database. so i was thinking like you said if i create a query in database 1 to give me all the records for one company how can i get that query into database 2 and create reports or forms etc but both databases must have the link between them
hope this makes sense
thanks
steve